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.