T-SQL ISNULL - System Functions example and syntax
T-SQL ISNULL System Function. Substitute NULL with the specified substituted value. ISNULL Syntax: ISNULL(expression , substitute_value) ISNULL Example: SELECT ISNULL('abc',28) as col_1, ISNULL('01/28/2014',7) as col_2, ISNULL(null,9) as col_3, ISNULL(null,null) as col_4, ISNULL('-',-1) as col_5; col_1 col_2 col_3 col_4 col_5 ...
DA: 80 PA: 26 MOZ Rank: 28