SQL - Query Help - Convert Varchar to numeric / decimal(10,2)
Posted on 2011-03-14
I have 2 columns, Waittime & Sessiontime - both are Varchar(255)
it has values like 1.23545578. I have cross checked the entire table. It doesnt have any non-numeric value.
How can I limit the value to decimal(10,2).
When I cast the column as decimal, it throws "Error converting data type varchar to numeric."