Replacing a comma (,) with a dot (.)

Question

I am using SSMS, beginner in SQL I want to replace varchar values which contains commas, to dots to parse through on other software which reads dots as floating values But from what I gathered, the Replace only works in a select and does not do it permanently. I want to see that 22 rows affected where commas was replaced

Example of data

HoursSpent
8,3
1,55
2,6
7,2

Example of end result

HoursSpent
8.3
1.55
2.6
7.2

If you want to change the value in the table permanently use `UPDATE` command — Squirrel, Jul 21 '22 at 06:19
The issue is with your database. Why do you store numbers as strings? Store them as numbers and you are fine. — Thorsten Kettner, Jul 21 '22 at 06:29
Once you have done the update you should then change the column datatype to something like `numeric(6,2)` and not store numbers as strings — Martin Smith, Jul 21 '22 at 06:29

score 1 · Accepted Answer · answered Jul 21 '22 at 06:20

1

You use UPDATE to make changes:

UPDATE table SET HoursSpent=REPLACE(HoursSpent,',','.');

answered Jul 21 '22 at 06:20

Tim Roberts

48,973
4
21
30

You saved me tons of time thanks – Duvan_K Jul 21 '22 at 06:31

Replacing a comma (,) with a dot (.)

1 Answers1