Luckily T-SQL has an ISNUMERIC(value) function:

select ISNUMERIC('PostalCode123') -- Returns 0
select ISNUMERIC('123') -- Returns 1

Therefore:

select *
from Customer
where ISNUMERIC(PostalCode) = 1

…returns only the rows where the varchar column PostalCode is numeric.

This entry was posted on Friday, January 16th, 2009 at 10:13 pm and is filed under SQL Server, Technology. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.