Is there a SQL Server equivalent of the Oracle 'decode' function?

I am trying to redeploy an Oracle system using a SQL server database, but am
getting a SQL error saying that 'decode' is not a vaild SQL command.
Is there a SQL Server equivalent of the Oracle function 'decode'?
IIRC, the equivalent is the CASE construct. Check it out in the BOL.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"elaine" <elaine@.discussions.microsoft.com> wrote in message
news:AA50F50A-EB1A-463E-BC93-0E6073108A75@.microsoft.com...
I am trying to redeploy an Oracle system using a SQL server database, but am
getting a SQL error saying that 'decode' is not a vaild SQL command.
Is there a SQL Server equivalent of the Oracle function 'decode'?
|||Use CASE function
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OZ0eFHPvEHA.592@.TK2MSFTNGP15.phx.gbl...
> IIRC, the equivalent is the CASE construct. Check it out in the BOL.
> --
> Tom
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
>
> "elaine" <elaine@.discussions.microsoft.com> wrote in message
> news:AA50F50A-EB1A-463E-BC93-0E6073108A75@.microsoft.com...
> I am trying to redeploy an Oracle system using a SQL server database, but
> am
> getting a SQL error saying that 'decode' is not a vaild SQL command.
> Is there a SQL Server equivalent of the Oracle function 'decode'?
>