update command
From: mh579 <mh579_at_bluecarrots.com>
Date: Tue, 16 Nov 1999 22:11:04 -0000
Message-ID: <3831d696_2_at_news1.vip.uk.com>
[Quoted] [Quoted] Due to a slight error on my part, users of our database have been allowed to [Quoted] enter text into a field in a format which contains spaces. This however is now causing problems with reports.
Date: Tue, 16 Nov 1999 22:11:04 -0000
Message-ID: <3831d696_2_at_news1.vip.uk.com>
[Quoted] [Quoted] Due to a slight error on my part, users of our database have been allowed to [Quoted] 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 [Quoted] 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 Tue Nov 16 1999 - 23:11:04 CET