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