Hi Ilya,

How about:

SELECT myfilename ;
   FROM myfile ;
   GROUP BY myfilename ;
   HAVING COUNT(*) > 1 ;
   INTO CURSOR sqlpass1

SELECT myfile.myfilename, myfile.myfilepath ;
   FROM sqlpass1, myfile ;
   WHERE myfile.myfilename = sqlpass1.myfilename ;
   ORDER BY myfile.myfilename ;
   INTO CURSOR sqlpass2

SELECT sqlpass2
COPY TO mytextfile.txt SDF

Hope this helps,
Gavin...

>Hello!!!
>I have a table which is field with the filenames from a directory and its subdirectories. One field in a table is a path an other one is a filename.
>I want to see if i have files with the same file names. The ones that do have same names i want sort them into a text file. How do i do that????
>Thank U.