SQL Server Transact Basic to Expert - Check if a given value is date or not using SQL

This blog shows how to check if the given value is date or not using the ISDATE keyword in SQL query Example: SELECT ISDATE('1/1/20110') The expected result would be 0 which means its not date value if a valid date is given it would return as 1