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'?
>sql