Sql Help

[Anon]

Hai,
Is there any function in MSSQL as in Oracle NVL.The fuction which substitue the given value if the selected Column is null in the select statement itself

Thanks in advance

[Anon]

Use ifnull() function.

select ifnull( column, 'N/A' ) as column_str from ...