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 |
|
thesupremegame
Starting Member
1 Post |
 Posted - 2007-07-19 : 00:43:49
|
| so heres my problem:i have a table with 6 colums and 50 rowsthe values are just : F or V and i want to put all the info into another table, but i wanna change all the F to V ... and the V to F.... do any1 know how can i do this? |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-07-19 : 00:55:17
|
| You can use CASE.CASE WHEN Column = 'F' Then 'V' When Column = 'V' Then 'F' Else Column ENDDinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
change values from a table to another one