Removing commas in fields of a table.

[dhaveedh]

Does anyone out there have any code that can check through all the fields in atable and replace all occurences of a comma with a space.

Any help will be appreciated.

Thanks

KISS - Keep It Simple Sugar!

 

[psemianonymous]

Uh, you can do a bunch of UDPATE queries, where you do

[tt]UPDATE tablename SET fieldname = Replace([fieldname], ",", " ")[/tt]


Look carefully and you'll see how that works. This will be quicker to set up than any code we might write.