Varchar to Integer Typecast

[Garimella]

I need to convert a varchar to Integer to compare if it is in the range. The problem is there might be few rows which have characters in them instead of numbers. This column either contains a number like '01','04', '15' etc or say a name. How can i achieve this? Is it possible.

[iburyak]

Something like this:
[PHP]

select cast(column_nam e as int) from table_name
where column_name not like '%[a-z,A-Z]%'[/PHP]

[almaz]

I guess better approach would be to use built-in functions ;)

select convert(int, convert(decimal, column_name)) from table_name
where isnumeric(column_name) = 1

Nested convert statements are required to handle fractional numbers