How to get non-numeric entries in a column of a database

sql-server-2008

Solution

select *
from customers
where ISNUMERIC(ccexperiation) = 0

With some minor caveats. See here.

Problem

I have customer database that we use for auto-charges. It would appear that the CC expiration field has a couple records with invalid entries for expiration date... for example non-numeric. Is there a way to search for entries with a NON-Numeric value? Below is the start of how I would assume the query would look... ``` select * from customers where ccexperiation = non numeric ``` Thanks.

Original source