You might also think about using the GROUP BY claus to net out with unique names.
>>I have a print file which is created by selecting addresses from multiple database files. Thereby, the same names may be selected
>>
>>Is there a simple way to command to filter the file for unique names?
>>I know I can sort and then compare records but was wondering if there is an easier way.
>>
>>Thanks
>>
>>Todd
>
>You might be interested in a unique index on your selection. Another idea is to
>SELECT from the first file ;
>UNION ;
>SELECT from the second file
>
>You can read about the difference between UNION and UNION ALL.
It's "my" world. You're just living in it.