OK. You could include leading/trailing blanks in your search string (i.e. [ SES ]) but that wouldn't help it it's the first word. Or as Tracy suggested, regex is an excellent way to go although I'd use Craig Boyd's most excellent Regexp library instead of the COM control.
rk -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MB Software Solutions, LLC Sent: Thursday, April 29, 2010 12:29 PM To: [email protected] Subject: Re: Need to replace word in sentence with * Richard Kaye wrote: > Why not use strtran()? Because of this scenario: STRTRAN("SES SENSES READING","SES","*") That would replace part of the other word with "SES" in it. I only want to do this for whole words in the sentence. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/df1eef11e586a64fb54a97f22a8bd0440682815...@ackbwddqh1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

