Can I use an optimizable query string to change
a key field or am I asking for trouble?

I'm looking at trying a statement something like:

REPLACE ALL PKey ;
    WITH XRef.NewPKey ;
    FOR PKey = XRef.OldPKey

- or possibly -

UPDATE TABLE Cust ;
    SET PKey = XRef.NewPKey ;
    WHERE PKey = XRef.OldPKey

I know that this kinda thing can hose a SCAN
loop.

Anyone have any experiences with this?

...kt