Subject Is this safe
Author Robert martin
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

Wild Software Ltd