Re: mssql server syntax equivalent for oracle

i found....DECODE function

hth
Christian

"Christian" <nomail_at_hips.doc> a écrit dans le message news: 9b723n$lsi$1_at_s1.read.news.oleane.net...
> hello,
>
> i'm trying to port an sql order from SQL Server to Oracle...and i have
 some
> trouble
>
> what would be the "Oracle" translation of the following "case" select ?
>
> SELECT CUSTOMERID,
> case when CUSTNAME is null then "no name"
> else CUSTNAME as NAME
> end
> FROM CUSTOMERS
>
> any help would be greatly appreciated
> Christian
>
>
>
Received on Fri Apr 13 2001 - 10:35:52 CDT