Reducing number of lines in code not necessarly makes it better.
>The code I gave you was for illustration only. The filespec is not hard coded. It is input by the user via a filepicker class similar to
>
>lcSourceTable = GETFILE()
>
>Thus the variable has the full filespec in it. I could use juststem or justfile to get just the filename but since the original table is not likely in the current directory I would have to be marching all over the disk to find it. Opening the table prior to the SELECT gives me the handle I need to close it but requires an extra step that I was hoping to avoid.
>
>
--sb--