Hello all. I have a query I am tring to implement and I can't wrap my
mind around it somehow. Can anyone help?



..



I have two tables within a database.



Within the first table, I have a blob field that basically has a large
amount of text.



Within the second table, I have a list of strings (in this case
application names).



Is there some way that I can search the blob for any occurrence of any
of the strings? (returning the string name)?



There could be more than 1 match.



Any ideas?



Thank you for any help you may offer.

Craig
--------------------------------------------------------
This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.