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 |
|
u2p_inst
Yak Posting Veteran
78 Posts |
 Posted - 2003-10-12 : 03:53:56
|
| dear all,i'm trying to use Select case in query:Select Case when(a is null and b is not null) or (c is null and d is not null) from table1something is wrong because i get an errorthanks!oh |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-10-12 : 03:56:53
|
Each CASE statement needs a THEN and an ENDSELECT CASE WHEN some condition THEN do this ELSE do something else ENDOwais
Make it idiot proof and someone will make a better idiot |
 |
|
|
u2p_inst
Yak Posting Veteran
78 Posts |
Posted - 2003-10-12 : 04:47:09
|
| thanks Owaisoh |
|
|
|
|
|
|
Case Expression