Problem Varchar to Float

Hi guys
I have a problem converting the data from varchar to float

I have numbers stored in the database as varchar like this (1,125.01)
and I want to read them as float so I can make calculations.

Please help.

Thank you much..... 🙂

Try looking into the CAST function of SQL, if you want to do the calculations in the query.

try this (works on MSSQL 7):

select cast(REPLACE(myvarcharnumber,',','') as float) from mytable

The REPLACE strips the commas, so the value can be converted using CAST

MySQL, unfortunately, can't CAST as a float, onlyt signed or unsigned integer, which drops everything after the decimal.