SQLAddict01 (2/11/2016)

---

I have a column with varchar data type but has numeric data in it

I know I can't use arithmetic operation for varchar

This is my query

select * from table1

where col1> 500.00

Msg 8115, Level 16, State 8, Line 38

Arithmetic overflow error converting varchar to data type numeric.

obviously it gives me this error.

what functions should I use to convert the data type?

I appreciate your help

Thanks