ISNULL (Transact-SQL) - SQL Server | Microsoft Learn If a literal NULL is provided as check_expression, ISNULL returns the data type of the replacement_value If a literal NULL is provided as check_expression and no replacement_value is provided, ISNULL returns an int