Need to extract words within brackets

It's a bit hard to answer this without knowing what DB system you're running.  But I will sy this: the best solution is probably going to be to do it entirely on the DB side of things, rather than dragging the stuff down to CF, monkeying with it, and popping it back up to the DB.  Unless you're using someing rubbish like Access, then your DB system will provide all the functionality you need, so there's no need to involve CF at all.  You could do it with CF, but it's not really what CF is designed for, whereas the DB itself is designed for doing this sort of thing.

So if I was you I'd look at what string manipulation your DB system offers, looking specifically at regex-oriented functions as a starting point.  You should be able to pull the keywords out of each record with one regex match if you're lucky.  If the regex support is less good, then doing it with a loop and a find & some substring extracts shouldn't be too hard.

However the ins and outs of how to do it on your DB of choice is probably a conversation best had on a DB-specific forum, if you can find a good one.

--

Adam