krakahed — Mon, 19 Nov 2001 13:45:51 +0000

Thanks for the reply, Peter. I will definitely try this approach and see if I can get this to work better. I've figured a work-around, but it would take a post longer than my first one to explain that one! LOL!

I will save you the headaches!

Anyway, thanx a heap for the help!

Peter J. Boettcher — Sat, 17 Nov 2001 15:44:09 +0000

Ouch, my head hurts

After reading what you're trying to do wouldn't a query like this suffice:

SELECT Product
FROM ProductTable
WHERE Product LIKE '%' + Product#
AND CONTAINS(Product, 'c')

Then just replace the 'c' with 'isa' or whatever other extension you're searching for. The query assumes that the variable Product# is going to be formatted properly.