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-12-19 : 09:03:14
|
| AdyJoss writes "how to use if or iif in query like in ms.accessexample=select iif(a=true,'A','B') as MyOpt from Customerfor this example how i use in sqlServerthank's" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-19 : 09:05:52
|
| Select case when a=true then 'A' else 'B' end as MyOpt from CustomerMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
How to use if or iif