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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Switch like statements in SQL

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-06-02 : 08:09:04
Subrahmanya writes "I want to know if MSSQL have any switch like statements. It must exactly working as "Select case" in VB.

Let me know
Thanks
Prasd"

SamC
White Water Yakist

3467 Posts

Posted - 2003-06-02 : 08:22:17
There is

CASE
WHEN condition THEN statement
WHEN condition THEN statement
....
ELSE statement
END

Fin more on CASE in Books OnLine.

Sam

Go to Top of Page
   

- Advertisement -