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 |
|
SQLBoy14
Yak Posting Veteran
70 Posts |
 Posted - 2015-01-21 : 12:23:24
|
| How do I case sql statement per below condition?If field1 = 2 and field2=D replace the Field3 with 253Field1 Field2 Field31 A 4542 B 2533 C 5522 D 225Thank youSQLBoy |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-01-21 : 12:33:55
|
| case when field1=2 and field2='D' then 253 else Field3 endTara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
SQLBoy14
Yak Posting Veteran
70 Posts |
Posted - 2015-02-01 : 09:26:32
|
| Thank you tkizerSQLBoy |
|
|
|
|
|
|
Case SQL question