maybe
update table set field1=field2, field2=field1
works?

> -----Original Message-----
> From: zaher [mailto:zaher@...]
> Sent: Monday, 26 May 2003 9:27 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Oooops i mean Exchange values between
> Fields in one Update
>
>
> sorry i asked in bad language, i mean Exchange values between
> Fields in one
> Update
> like
>
> tmp=f1
> f1=f2
> f2=tmp
>
> i am ask just for talking
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>