Friday, 15 May 2015

Check whether a column has any letters or not

check whether a column has any letters or not

SELECT *
FROM    myTabet
WHERE   ISNUMERIC (myColumn) = 0

No comments:

Post a Comment