Hi Mohammed,

>how i can do that via vfp5,or vfp8.

You can't do it with a SQL SELECT statement in VFP8 (or an older version of vfp) because a SQL SELECT statement uses the unbuffered data (in those versions).
You can use the GETNEXTMODIFIED command to look which records have been modified though.

hth,