Unable convert varchar to Decimal, in dynamic query

[VIJSQL01]

hi,

i am unable to convert Varchar to Decimal. I am getting error as follows.

Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to numeric.

SQL query used:

select * from RT_STATE_MASTER where Convert(Decimal(10,4),CAP_RATE_MEAN)<0

i would like to mention here that, when i execute the query, the results appears and suddenly disappears by throwing the above error message. Earlier i never faced this kind of issue. For the same query, i used to get the results. This is something new and weird for me.
Please advise on this. Thanks.

 

[fredericofonseca]

try this query

select * from RT_STATE_MASTER where isnumeric(CAP_RATE_MEAN) = 0

The rows returned will be cause of your problems

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[VIJSQL01]

Great! Thank You Thank You Thank You....Thanks a ton. This solution worked for me!