DECODE in SQL Server?"

[N]

What is the function in SQL that works like DECODE in Oracle?"

Thanks,

N

[David Portas]

Use CASE

--
David Portas
SQL Server MVP
--

[N]

SELECT CASE WHEN Assignment_Type = 'C' THEN 'Com' ELSE 'Donot Know'
FROM ASSIGNMENT

When I try to use CASE WHEN, it gave me error [Microsoft][ODBC SQL Server
Driver][SQL Server]Incorrect syntax near the keyword 'FROM'. What did I do
wrong?

Thanks

"David Portas" <RE****************************@acm.org> wrote in message
news:24********************@giganews.com...

Use CASE

--
David Portas
SQL Server MVP
--

[David Portas]

> What did I do

wrong?

You didn't read-up on the syntax first! My reply was intended as an
indication of something you should look up. You'll find Books Online is a
great resource if you refer to it occassionally :-)

SELECT CASE WHEN Assignment_Type = 'C' THEN 'Com' ELSE 'Do not know' END
FROM ASSIGNMENT

or

SELECT CASE Assignment_Type WHEN 'C' THEN 'Com' ELSE 'Do not know' END
FROM ASSIGNMENT

--
David Portas
SQL Server MVP
--

[N]

David,

Sorry, I don't have books online. The examples I found on the site, none of
them used "END" in the statment.

Thanks a bunch! ^_____^
N
"David Portas" <RE****************************@acm.org> wrote in message
news:5M********************@giganews.com...

What did I do
wrong?

You didn't read-up on the syntax first! My reply was intended as an
indication of something you should look up. You'll find Books Online is a
great resource if you refer to it occassionally :-)

SELECT CASE WHEN Assignment_Type = 'C' THEN 'Com' ELSE 'Do not know' END
FROM ASSIGNMENT

or

SELECT CASE Assignment_Type WHEN 'C' THEN 'Com' ELSE 'Do not know' END
FROM ASSIGNMENT

--
David Portas
SQL Server MVP
--

[David Portas]

Get BOL here:
http://www.microsoft.com/sql/techinf...00/default.asp

--
David Portas
SQL Server MVP
--

[Daniel Morgan]

N wrote:

What is the function in SQL that works like DECODE in Oracle?"

Thanks,

N

As you know CASE is not the same as DECODE ... but SQL Server hsa no
functionality equivalent to DECODE so you will have to adapt CASE to
do the job.
--
Daniel A. Morgan
University of Washington
da******@x.washington.edu
(replace 'x' with 'u' to respond)

[Serge Rielau]

Daniel Morgan wrote:

N wrote:

What is the function in SQL that works like DECODE in Oracle?"

Thanks,

N

As you know CASE is not the same as DECODE ... but SQL Server hsa no
functionality equivalent to DECODE so you will have to adapt CASE to
do the job.

How is DECODE different than "simple CASE"?
(Other than that DECODE is a function and CASE an expression, of course...)

Cheers
Serge

[Muhd]

You can also find the books online online at

http://msdn.microsoft.com/library/de...server2000.asp

Open up the SDK Documentation tree item.

Muhd

"David Portas" <RE****************************@acm.org> wrote in message
news:5a********************@giganews.com...

Get BOL here:
http://www.microsoft.com/sql/techinf...00/default.asp

--
David Portas
SQL Server MVP
--

[DHatheway]

"Daniel Morgan" <da******@x.washington.edu> wrote in message
news:1096932539.547042@yasure...

N wrote:

What is the function in SQL that works like DECODE in Oracle?"
Thanks,

N

As you know CASE is not the same as DECODE ... but SQL Server hsa no
functionality equivalent to DECODE so you will have to adapt CASE to
do the job.
--
Daniel A. Morgan
University of Washington
da******@x.washington.edu
(replace 'x' with 'u' to respond)

OK, then, what does DECODE do?

[-P-]

"DHatheway" <dl********@mmm.com.nospam> wrote in message news:ck**********@tuvok3.mmm.com...

"Daniel Morgan" <da******@x.washington.edu> wrote in message
news:1096932539.547042@yasure...

N wrote:

What is the function in SQL that works like DECODE in Oracle?"
Thanks,

N

As you know CASE is not the same as DECODE ... but SQL Server hsa no
functionality equivalent to DECODE so you will have to adapt CASE to
do the job.
--
Daniel A. Morgan
University of Washington
da******@x.washington.edu
(replace 'x' with 'u' to respond)

OK, then, what does DECODE do?

DECODE( exp, search1, result1 [,search2, result2]... ) is semantically equivalent to:

CASE exp
when search1 then result1
when search2 then result2
... END

The difference between CASE and DECODE is that CASE also allows the form:
CASE
WHEN exp1 = search1 then result1
WHEN exp2 = search2 then result2
... END

DECODE can't do that.

--
Paul Horan[TeamSybase]

VCI Springfield, Mass
www.vcisolutions.com