Hi all. Got a question for you. Can I use a rerefindnocase in the WHERE statement of a SELECT query? Right now, I'm building them like this? WHERE foo like '#bar #%' <-- picks up full word at the beginning of a field or foo like '% #bar# %' <-- picks up full word in the middle of a field or foo like '% #bar#.' <-- Picks up full word at end of sentence at end of field. The last two is where I want to place the regexp. In order to pick up a full word with a comma, period, exclamation point or question mark, I'd need several like clauses. I'm not very learned in regular expressions. I'd like to change the last 2 to pick up a full word in the middle of a field (#%') or at the end of a field (#') with one of the characters I mentioned (and a space for the 2nd one) at the end of the word, like: foo like '% bar#.,[space]?!' Can it be done? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ------------------------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]