Re: mssql server syntax equivalent for oracle

try

SELECT CUSTOMERID,DECODE(CUSTNAME,NULL,'No Name',CUSTNAME) NAME FROM CUSTOMERS; "Christian" <nomail_at_hips.doc> wrote:

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

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Fri Apr 13 2001 - 10:35:02 CDT