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.