How to get non-numeric entries in a database column

Question

I have a customer database that we use for automatic payment. It looks like the CC expiration field has a couple entries with invalid entries for the expiration date ... for example, non-numeric. Is there a way to search for entries with a NON numeric value? Below is an example of how I assume the query will look ...

select * from customers where ccexperiation = non numeric 

Thanks.

Answer 1

 select * from customers where ISNUMERIC(ccexperiation) = 0 

With some minor reservations. See here .