Dealing with NULL Data - the ISNULL Function : ISNULL « Select Query « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Select Query
  3. ISNULL

Dealing with NULL Data - the ISNULL Function

1> -- Dealing with NULL Data - the ISNULL Function
2>
3>
4> select ISNULL(NULL, 5)
5>
6> GO

-----------
          5

(1 rows affected)
1>








Related examples in the same category

1.Using ISNULL in select statement
2.ISNULL allows a display of the specified value as substitution for NULL
3.ISNULL function demo
4.ISNULL(5, 15)
5.ISNULL with subquery