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 |
|
dim
Yak Posting Veteran
57 Posts |
 Posted - 2010-12-23 : 14:20:57
|
| Hi,I am in process of converting oracle code to SQL Server 2005. I need to verify whether my interpretation is correct. decode(bp.cd,'VA',0,'VM',0,1)case when bp.cd = 'VA' then 0 else 1 end )Please advice.Thank you,Dp |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2010-12-23 : 14:38:30
|
| We'd have to know the right answer in Oracle. That 'VM' is used for some reason:case whn bp.cd in ('VA','VM') then 0 else 1 end ?JimEveryday I learn something that somebody else already knew |
 |
|
|
|
|
|
Decode SQL Server Equivalent