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

bob popular · #3 (**permalink**) 06-29-11, 16:09

That's good to know. I was wondering the same thing since I've been back in Oracle dabbling with SQL again. I guess my question is whether there is SQL SRVR equivalent function to DECODE or if you have to implement the more verbose option. Any ideas?

Thanks in advance!

Wim · #4 (**permalink**) 06-29-11, 16:45

Create a function called dbo.decode with achorozy's solution if you feel typing the CASE statement takes too long.

Anyway, if you don't know how a CASE construct works, take the (very) short time it takes to learn it. It can be very handy.

Internet Services

Web Development

Digital Marketing

Consumer Tech