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 - 2002-02-19 : 08:58:13
|
| alfredo writes "does exist (in sqlser) a function like iif (in access) or decode (in oracle) ?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-19 : 09:19:04
|
| Yes, there is the CASE statement. It's not technically a function, but it has a syntax that's very similar to decode.Look in Books Online for more details, also search SQL Team for "CASE" and read the articles, there's plenty of really good examples on how it works. |
 |
|
|
|
|
|
question about a function