what is the equivalent syntax in MSSQL for DECODE() in Oracle?
Printable View
what is the equivalent syntax in MSSQL for DECODE() in Oracle?
You will have to use case statement for that. There is no decode in MS SQL.
Here 's the syntax.
CASE input_expression
WHEN when_expression THEN result_expression
[ ...n ]
[
ELSE else_result_expression
]
END
Searched CASE function:
CASE
WHEN Boolean_expression THEN result_expression
[ ...n ]
[
ELSE else_result_expression
]
END
If you want more info on this, visit the following link.
[URL="http://msdn2.microsoft.com/en-us/library/ms181765.aspx"]MSDN Link[/URL]
Cheers!
Kalayama