Equivalent of Oracle's DECODE function on SQLServer

jofph · #1 (**permalink**) 03-04-02, 14:58

What is the equivalent function in SQL server for the DECODE function in Oracle?

For example:
select decode(customer_type,'B','Business','Non Business')
from CUSTOMER_TABLE

This is the function statement that we use currently in Oracle. I need to do this same function in Sql server.

Thanks for all help.

achorozy · #2 (**permalink**) 03-04-02, 15:29

I'm assuming that customer_type may or may not contain the character 'B'.

For SQL Server

Code:

SELECT CASE customer_type
                 WHEN 'B' THEN 'Business'
                  ELSE 'Non Business'
            END
FROM CUSTOMER_TABLE 

OR

SELECT CASE WHEN customer_type = 'B' THEN 'Business'
                  ELSE 'Non Business'
            END
FROM CUSTOMER_TABLE