View Single Post
  #1 (permalink)  
Old 03-04-02, 15:58
jofph jofph is offline
Registered User
 
Join Date: Mar 2002
Posts: 4
Equivalent of Oracle's DECODE function on SQLServer

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.
Reply With Quote