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.

 All Forums
 Site Related Forums
 Article Discussion
 Article: The case for CASE

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-10-05 : 22:59:46
We get many questions asking whether it's possible to use an IF clause inside a SELECT statement. Well, not exactly. But you can use CASE to do the exact same thing.

Article Link.

r937
Posting Yak Master

112 Posts

Posted - 2003-10-20 : 14:57:41
the last two examples in the article are missing the END keyword

rudy
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2003-10-20 : 16:02:33
Heh. Three years those have been wrong. Thanks for pointing it out. And it's fixed.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page
   

- Advertisement -