Use
ISNUMERIC[
^]. From this link,
The following example uses
ISNUMERIC
to return all the postal codes that are not numeric values.
USE AdventureWorks2012;
GO
SELECT City, PostalCode
FROM Person.Address
WHERE ISNUMERIC(PostalCode)<> 1;
GO
Change the query based on your requirement.