Something like reReplaceNoCase( "\b(and)\b", string, "<strong>\1<\\strong>", "all" )
Not sure if its in the right order though, don't have time to check. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -----Original Message----- > From: Ryan Guill [mailto:[EMAIL PROTECTED] > Sent: Friday, 23 September 2005 6:54 AM > To: CF-Talk > Subject: regex help > > > hey guys, need some more regex help > > I am wanting to match the word and, for instance in the > following query: > > SELECT > brbrch, > brname, > brst||char(brbrch) > FROM tn9997/sybr > where brregn=5 > and bract='Y' > > with regex. How could I make it where it will match any > whitespace (linefeed, carrage return or a space) right before > the word and and then surround just the word and with > <strong> tags ? or even better yet, also, if the word and is > lowercase, I would like it capitolized as well, but thats not > as importaint yet. > > Any takers? > -- > Ryan Guill > BlueEyesDevelopment > [EMAIL PROTECTED] > www.ryanguill.com > (270) 217.2399 > got google talk? Chat me at [EMAIL PROTECTED] > > The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219046 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

