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

Question

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.

Answer 1

select *
from customers
where ISNUMERIC(ccexperiation) = 0

With some minor caveats. See here.