Wai,

In addition to Nadya's reply, if you want the export in a format other than a VFP6 dbf you can use the COPY TO ... TYPE ... after you've run the SELECT.

>i want to know if i use select - SQL to do some filtering from one table abd i want to export this filtered file and save it into my local harddisk. How can i do this?? can anyone help me?