SQL THOUGHTS– ISNULL FUNCTION IN SQL

ISNULL
If we want to check whether a column value is null and replace it with some value we can use this function


SYNTAX

SELECT ISNULL(COLUMN_NAME, REPLACEVALUE) FROM TABLE_NAME

SELECT ISNULL(STARTDATE, 0) FROM TABLE_NAME

HappyCoding !

About these ads