SQL Server Forums - Article: The case for CASE

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

Site Related Forums

Article Discussion

Article: The case for CASE

New Topic

Reply to Topic

Printer Friendly

Author

Topic

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 10/05/2000 : 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.

coho
Starting Member

USA
3 Posts

Posted - 10/31/2001 : 11:49:37

But CASE still cannot do nondeterministic parsing. How can I do this...

CASE aTable.NumColumn
WHEN aTable.NumColumn > 0 THEN 'Positive'
WHEN aTable.NumColumn < 0 THEN 'Negative'
ELSE 'Exactly Zero'
END

izaltsman
A custom title

USA
1139 Posts

Posted - 10/31/2001 : 11:57:56

Actually, you almost had it:

SELECT CASE
WHEN aTable.NumColumn > 0 THEN 'Positive'
WHEN aTable.NumColumn < 0 THEN 'Negative'
ELSE 'Exactly Zero'
END

r937
Posting Yak Master

Canada
112 Posts

Posted - 10/20/2003 : 14:57:41

the last two examples in the article are missing the END keyword

rudy

graz
Chief SQLTeam Crack Dealer

USA
4128 Posts

Posted - 10/20/2003 : 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.

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.08 seconds.