Microsoft SQL Server 2005 Best Practices

How to apply ISNULL with datetime column?


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 BirthDate=ISNULL(BirthDate, '1900-01-01') from HumanResources.Employee


The World Leader in SQL Server Training Home Page