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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-19 : 08:00:20
|
| Rick writes "An update query was run in error against a table and updated a text field using the upper(fieldname option). We wish to revert this text back to the mixed case format that it previously had. Example - the data value "the oak tree" should be stored as "The Oak Tree"Appreciate any ideas, thanks." |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-08-19 : 08:02:47
|
| You should do this type of updates with Begin TransactionIf you are satisfied with the result you can commit it otherwise rollback itIf you have backup, then restore itMadhivananFailing to plan is Planning to fail |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-19 : 08:39:11
|
| Or you could perhaps restore the backup to a temporary database, compare the columns and where the data is the same (case insensitive) but different (case sensitive) replace the current data with that from the restored databaseKristen |
|
|
|
|
|
|
Uppercase conversion to Mixed Case