CLOSE DATABASES ALL SET SAFETY OFF CREATE TABLE Test1 (dt t) =RAND(234) FOR X = 1 TO 1000 INSERT INTO Test1 (dt) VALUES (DATETIME()+ROUND((RAND()*10000),0)) ENDFOR COPY TO Test2 SCAN m.tDate = Test1.dt REPLACE Test1.dt WITH m.tDate m.tDate = Test1.dt SELECT * FROM Test2 WHERE dt=tDate INTO CURSOR Temp IF RECCOUNT()#1 USE SELECT Test2 LOCATE FOR TTOC(Test1.dt)=TTOC(Test2.dt) ? FOUND(),Test1.dt,Test2.dt,Test1.dt=Test2.dt CANCEL ENDIF USE SELECT Test1 ENDSCAN RETURNIt was interesting to note that Test1.dt=Test2.dt does return .T. even though the select fails to locate the matching record.