CREATE TABLE Table1 (Id Int,Field1 C(30)) >INSERT INTO Table1 VALUES(5 ,"555555555555") >INSERT INTO Table1 VALUES(3 ,"333333333333") >INSERT INTO Table1 VALUES(2 ,"222222222222") >INSERT INTO Table1 VALUES(10,"101010101010") >INSERT INTO Table1 VALUES(5 ,"double555555") >BROWSE NORMAL >select * from table1 into cursor _tmp READWRITE > >GO TOP >LOCATE FOR ID = 3 >REPLACE Field1 WITH "update333" > >GO TOP >LOCATE FOR ID = 5 >REPLACE Field1 WITH "update555" > >UPDATE Table1 SET table1.field1 = _tmp.field1 FROM _tmp WHERE table1.id = _tmp.id > >SELECT Table1 >BROWSE NORMAL>HTH