I could try that anyway. If Linking to the second table adds a lot of time, then perhaps I could create a concatenated set of SKUs in the MfgProducts...

I thought so initially, but it turns out that it isn't. For example, Company A may give there Widget at SKU of 1234. Company B may give there...

I'll play with that. I can do it for part numbers but not for the part name. For example, if a user searches for 'resistor' and that part...

Hmmm... incidentally, I did the concatenation into the SearchString thinking it would be faster than searching 3-4 different varchars. Also, some of the part numbers are thinks like 45-1234565...

Thank you both for your replies. I'll look into the full text searching today.

Here's an example product:

Supplier Index: 1235893

SKU: 39KTZ5661

Cost: 14.35

Availability: 5

ManufacturerID: 72

Manufacturer: System Direct

Manufacturer Part #: 6192 2.3...