Re: update command

back to the basics

update table
set field=translate(field,' ','_');

mh579 wrote in message <3831d696_2_at_news1.vip.uk.com>...
>Due to a slight error on my part, users of our database have been allowed
to
>enter text into a field in a format which contains spaces. This however is
>now causing problems with reports.
>
>the solution is to amend each row in the table concern to update the space
>to a _ or /. I can do the update sql using a known input ie gse 123 and
then
>update to gse_123 or gse/123 but I would like to update all errors with one
>sql command. I have tried selecting the rows with the incorrect format and
>then updating them but to no avail!!!
>
>could anyone please help
>
>Martin Hopkins
>
>
Received on Wed Nov 17 1999 - 03:14:22 CET