Remove a single character from a varchar field with SQL

It is very simple, You can update the table directly using REPLACE on the column values:

UPDATE yourTable
SET yourColumn = REPLACE(yourColumn, ‘.’, ”)