That was it I didn't have it on the first section.

I don't know of any other way to preform what I need to do other then those options.

I need the right as there are about 20,000 rows. The way it is setup is each item could have two prices based on what the customer selects. So if they pick level 1 they get price one, level 2 gets price 2. This is determined by the last letter of the option code. Any thoughts on that?

The wild card is to make it a bit easier for the user and not having to type out the everything.

It is a third party table so I don't to mess with anything and use full text index searching.