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, ‘.’, ”)
It is very simple, You can update the table directly using REPLACE on the column values:
UPDATE yourTable
SET yourColumn = REPLACE(yourColumn, ‘.’, ”)