ISNULL is a convenient default setter for a string column usually to empty string ”.

With a DateTime column you have to pick a characteristic date like the following:

 

SELECT ISNULL(<ColumnName>, '1900-01-01') from <TableName>

 

Happy Coding

Advertisements