How about a series of STRTRANs looking for the word with leading and trailing spaces as well as punctuation marks. You could add a space at the beginning of the string to handle cases where the target is at the beginning of the line as long as you take it away after the the STRTRAN.
HTH - Joe On Thu, Apr 29, 2010 at 12:28 PM, MB Software Solutions, LLC < [email protected]> wrote: > 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. > > -- > Mike Babcock, MCP > MB Software Solutions, LLC > President, Chief Software Architect > http://mbsoftwaresolutions.com > http://fabmate.com > http://twitter.com/mbabcock16 > [excessive quoting removed by server] _______________________________________________ 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/[email protected] ** 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.
