Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ismailc
Constraint Violating Yak Guru
290 Posts |
 Posted - 2010-02-24 : 13:10:44
|
| Good day, I have an application where all it's code is stored in a sql db.Now i have to change a value in the entire application which i know i will miss something.And thought of searching the field for the value "TEST" & replace with "Test"I ahve to update the table field only where the value is found not all records have the text - so i have to be 100% sure it only updates where finds as the application will not work if upd incorrectly.Please Help |
|
|
ismailc
Constraint Violating Yak Guru
290 Posts |
Posted - 2010-02-24 : 13:13:29
|
| here is an example of how the field looks with some rowsif "aObjects("VE10EXTVendorAppDis")" = "True" then fclabel = "N/A" End |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-25 : 09:38:53
|
| you mean searching inside appln code or searching in db?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Search field and replace only searched text value