RE: Changing multiple records dynamically

2003-10-23 Thread Dan Greene
t; Sent: Thursday, October 23, 2003 9:53 AM > To: Rob > Cc: [EMAIL PROTECTED] > Subject: RE: Changing multiple records dynamically > > > Hi Rob, > > Definitely trying to do a value swap. > > Regards, > David > > --- Rob <[EMAIL PROTECTED]> wrote: &

RE: Changing multiple records dynamically

2003-10-23 Thread Mumba Chucks
Hi Rob, Definitely trying to do a value swap. Regards, David --- Rob <[EMAIL PROTECTED]> wrote: > Are you trying to do a value swap or are you just > updating? If you are > updating you could simply do > > UPDATE table > SET DEFG = 11, > HIKJ = 12 > > -Original Message- > From: Mumba