Thanx Jeff,

I already altered the SP to do just that.

I do not really need the attributes except for the size.

and I guess I probably do not need to keep a permanent table.

What I'm trying to do is grab the filenames from a directory and see if there are 2 files with the same name and different extensions..

ie:

123.txt and 123.pdf

I want it to check and find all txt files that do not have a corresponding pdf file and output those txt filenames to the results of the query.

I have been trying to work on a query using:

left(FileDetails.[Name],len(FileDetails.[Name])-4)

This will give me the filenames without the extension and I've been trying for a while to get my results to no avial...

Can anybody help me?