Re: mssql server syntax equivalent for oracle

On Fri, 13 Apr 2001, 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

Look up the "decode" statement and see what you can come up with.

-- 
I don't want to be the rock.  Yeah, okay, what do you want to be?
I want to be the piece of glass.