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 2008 Forums
 Transact-SQL (2008)
 Decode oracle function equivalent in sql server

Author  Topic 

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2012-02-09 : 12:22:42
Is there a decode equavalent function in sql server.

In oracle there is decode function.

Thanks a lot for the helpful info.

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-02-09 : 12:27:43
The closest I can think of are IF-THEN constructs or CASE expressions.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-09 : 13:58:37
i feel its analogous to CASE..WHEN

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -