That worked for me!  Thanks Scott!

Thanks for your reply, Brian.

Strings for the manufacturer number will ALWAYS be *<manufacturer #>*.  Staff at my organization have to manually enter this information into the field I am pulling...