search engine for text blobs

Hi, I was wondering how you people have implemented search engines on text blobs. For example, I am going to keep track of trouble calls from the software support department. I will save the notes from each support call into a text blob that is part of the support call record. I would like some way of searching those notes in the blobs for a specific string, like "AIX" or "-408". I really don't want to select each blob out of the database and then "grep" it. That might be a little slow. 8-) I could generate a keyword list from the notes, and search using the keywords, but I wanted to see if anyone had a better way? So, anyone have a better way? Thanks, Alan ------------------------------------------------------------------------------ Alan Goodman | Data Systems Support Senior Systems Analyst | A Client Technologies Company internet : alan@dssmktg.com | 1228 Shelly Ct. Voice 714-771-0454 Fax 714-771-3028 | Orange, CA 92668 USA ------------------------------------------------------------------------------