ISNUMERIC() function Help
641325Mar 11 2009 — edited Mar 11 2009Hello,
I am having an table with the column type as
varchar.
The column value may be anything.Its include
numbers,Strings,*,#,%.etc..
But i like to gee the values which is in between
0 to 100.
So i tried as
select attribute2 from history where
ISNUMERIC(attribute2)=1 and cast(Attribute2
as integer) < cast('100' as integer) and
cast(Attribute2 as integer) > cast('0' as
integer)--attribute2<>100
Here
attribute2 - column name varchar
History - table name
Its giving the following error "cannot convert #
to int".
But i am filtering the column values by
ISNUMERIC(attribute2)=1 before casting to
integer.
Please any one guide me to solve this issue!!!
Thank you!!!