Please start any new threads on our new site at 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 

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.

Posting Yak Master

112 Posts

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

Go to Top of Page

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 -