Powertips

Use the ISNUMERIC function of the sql server to this job.

To check all records of that particular column if it contains a string or can be converted to numeric use the script below.

select
case when sum(
case when COLUMN_NAME is null then 1
when ltrim(rtrim(COLUMN_NAME)) = ” then 1
else isnumeric(COLUMN_NAME)
end) = count(*) then 1 else 0 end x from TABLENAME

You can find more info here

cast, convert, isnumeric, sql server

This entry was posted on Wednesday, May 19th, 2010 at 11:25 am and is filed under Database, MS SQL Server, SQL Server 2008. 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.