What I'm trying to do is grab a list of files with a certain extention, and split the file name and file extension in two. That part I know how to do.

Now I need to take each file name and compare it with the ID field of each record in a database. If the name matches an ID, then I need to change the file name variable's value to the value in the second field of the database, otherwise, leave the names as is.

Can someone give me hint?

--Drew