AW: SQL UPDATE which field to SET?

You may also use a single select:

Update MyFile
Set Fld1 = Translate(Fld1, ' ', '.'),
Fld2 = Translate(Fld2, ' ', '.'),
....

But for a quick and dirty solution 15 Updates may be faster ;)

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von David FOXWELL
Gesendet: Wednesday, 31. March 2010 08:26
An: Midrange Systems Technical Discussion
Betreff: RE: SQL UPDATE which field to SET?


Sorry, stupid question, I may as well just do 15 updates changing the field
name each time.

-----Message d'origine-----
De : David FOXWELL
Envoyé : mercredi 31 mars 2010 08:23
À : 'Midrange Systems Technical Discussion'
Objet : SQL UPDATE which field to SET?


Hi,

I can select the records I want to update like this.

Select * from myfile where
field1 = '.' or
field2 = '.' or....
field15 = '.'

There are 15 fields that may contain the value '.'

How can I update any field that contains a '.' to the value '
' without touching any other fields?