mssql server syntax equivalent for oracle

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 - 09:25:19 CDT