Hi all from Spain.

I need to search with criteria over a varchar2 fiel that includes html tags. I would like to ignore the tags in my search.
For example:
If I´ve got the text "<strong>Hello world</strong>" in the database field, and I search from my application by the text "strong" (using criteria ilike method) I`ll obtain "Hello world" as result. I need html tag text was ignored.

Thanks in advance.

I think you can use SAX parse to parse the html tag
http://en.wikipedia.org/wiki/Simple_API_for_XML

Thank you very much for your answer.

I think SAX is a good idea if I has the text-with-tags in a file or in a string, but I need ignore the tags while criteria is doing the search over the database.
I am looking for a way to use regular expresions (or so) to ignore everything between "<" and ">" characters while I am searching with criteria on the database.

Any idea?