ISNULL SQL Server

SQL Server > Built-In Functions > ISNULL



Replaces NULL with the specified replacement value.

Example

SELECT
 isnull(last_name,'N/A') last_name
FROM
 person