RE: SQL UPDATE which field to SET?

[David FOXWELL <David.FOXWELL@xxxxxxxxx>]

Hi, Birgitta,

That doesn't quite work.

If I have :
Field1    Field2    Field3
Hello.    HowrU.    .

I only want to update Field3. That's what I meant when I "wrote without touching any other fields"



> -----Message d'origine-----
> De : midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Birgitta Hauser
> Envoyé : mercredi 31 mars 2010 09:21
> À : 'Midrange Systems Technical Discussion'
> Objet : 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?
> --
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list To post a message email: 
> MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change 
> list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, 
> please take a moment to review the archives at 
> http://archive.midrange.com/midrange-l.
>
>
> -- 
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.