Finding And Renaming Image.

Heres what im trying to do, I have mssql databse full of about 15,000 item ID codes. For Example of the ID Code:

The first 2 sometimes 4 letters represents the distributor name, the numbers are the item number and BX for example means Box.

DJ3726
DJ3847BX
DJ3743CD
PD2374
PD2334
PD4334BX

And I have about 15,000 images from my distributrs that mostly match up to the actual ID number, but still a lot dont match up because of a small extra letter like BX Or somehting like that.

So what ive done was write a code that Splits out the Manufature code for example DJ from DJ3726BX, and also the same for the item ID 3726 from DJ3726BX, So when I put thos to together I get just the manufature name and ID code instead of the extra crap I dont need.

And now I take just the Manufacutre name and ID and looping through my database and all of the (images via File Scripting Object).

Then I check to see if the manufacure code and ID is in the item name. For Example

Check if DJ74637
IS In: DJ74637BX.GIF

Then if it finds a match it gos and renames the gif for me. And it loops through untill its done.

My problem is that it just doesnt work, no errors no anything it just doesnt pick up any images when I can visualy go through my self and find some matchs.

Heres my code that I came up with so far ....