SEO

#1 (**permalink**) 02-29-2008, 04:26 AM

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

Thanks,

N

#2 (**permalink**) 02-29-2008, 04:26 AM

Use CASE

--
David Portas
SQL Server MVP
--

#3 (**permalink**) 02-29-2008, 04:26 AM

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" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message
news:24GdncWmqJeLKfzcRVn-vg@giganews.com...
> Use CASE
>
> --
> David Portas
> SQL Server MVP
> --
>
>

#4 (**permalink**) 02-29-2008, 04:26 AM

> 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
--

#5 (**permalink**) 02-29-2008, 04:26 AM

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" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message
news:5MGdne_kiKNeKvzcRVn-gw@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
> --
>
>

#6 (**permalink**) 02-29-2008, 04:26 AM

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

--
David Portas
SQL Server MVP
--

#7 (**permalink**) 02-29-2008, 04:26 AM

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
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

#8 (**permalink**) 02-29-2008, 04:27 AM

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

#9 (**permalink**) 02-29-2008, 04:28 AM

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" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message
news:5aOdncEAVOgnX_zcRVn-tA@giganews.com...
> Get BOL here:
> http://www.microsoft.com/sql/techinf...00/default.asp
>
> --
> David Portas
> SQL Server MVP
> --
>
>

#10 (**permalink**) 02-29-2008, 04:28 AM

"Daniel Morgan" <damorgan@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
> damorgan@x.washington.edu
> (replace 'x' with 'u' to respond)
>

OK, then, what does DECODE do?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

DECODE in SQL Server?"