Tell me, pliz, how to change the data presented in formatted text ($ 100.00) to numeric, to calculate the amount? Tell me how to write the correct code in SQL?

    1 answer 1

    Something like this: CAST(Replace('$100.00','$','') as FLOAT)

    Here is an example of a query to an abstract table:

     Select SUM(CAST(Replace(Value,'$','') as FLOAT)) from Table