Sql Isnull Nvl And Ifnull Functions

Employees Table In this example, when we query the employees table, we want to replace null values in the employeeName field with ‘Unknown’. Syntax Example Results The SQL ISNULL function can be very helpful when null values need to be replaced in the result set with alternate information.