Wanting to restrict search

[BimmerBoy]

I have a page that I use to search through db entries. Some of these entries
contain HTML and other HTML-like markup and the contents of the tags is turning
up in a search. Is there a way to get the query to ignore this stuff? I have
tried a couple of things but have had no luck. Any help with this matter would
be greatly appreciated!!

[MikerRoo]

Is this a SQL query or a Verity query?
How is the HTML stored? Is it raw (bad form, old chap) -- ie. <?
Or HTML encoded? Ie. <

Here's a general purpose approach that should work:
A) to just stop the HTML from displaying, strip it from the string using
REReplace.
Something like:
<CFSET sStrippedStr = REReplace (sRawStr, "<.+>", "","ALL")

B) To weed false search hits, due to tag contents maybe something like the
following...
1) query as before.
2) loop through the query rows, and change the contents to the stripped value,
as in step A.
4) Using the original criteria, query the updated query set. That is, run a
QofQ on the stripped data -- false hits will not be in the final set.

Consider posting exact examples of what you have, versus what you want.

Regards,
-- MikeR