Hi All

Can I do the following

Update tablename
Set FieldA = FieldB, FieldB = NULL

and expect FieldA to have the old value from FieldB and FieldB to now be
Null? Will this have problems with optimization etc?

I suppose what I am really asking is, is the order of entry important?


--
Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd