Tuesday, November 30, 2010

SQL Server Builtin functions to validate the data

Recently I came across a scenario in which I need to validate the data against the datatype.
After some searching I found the below SQL Server Builtin functions to validate the data.

ISNULL
ISNUMERIC
ISDATE
Eg:
SELECT ISNUMERIC('1234')--Returns 1 for success and 0 for failure.
SELECT ISDATE('11-30-2010')--Returns 1 for success and 0 for failure.

If you find relevant information, please update here so that I will publish with due credit.
Regards,
DP.

No comments:

Post a Comment