>>
>>
>>lcTestString = replicate("ABCDEF",100000)
>>? LEN(lcTestString), SECONDS(), IIF(LEN(strtran( lcTestString, "BDF", "" ))>0, SECONDS(), 0)
>>lcTestString = replicate("ABCDEF",100000)
>>? LEN(lcTestString), SECONDS(), IIF(LEN(Chrtran( lcTestString, "BDF", "" ))>0, SECONDS(), 0)
>>
>>
>>just to give you an idea and a coffee break <g>. For lunch up the ante.
>>
>>rgds
>>
>>thomas
>
>From Steve Black's site:
>
>
http://www.stevenblack.com/text.asp>
>"However don’t try to use CHRTRAN() when the second parameter is an empty string. The performance of CHRTRAN() in these circumstances is terrible. If you need to suppress sub-strings, use STRTRAN() instead."
Uh huh. I agree completely. Didn't say it worked WELL, just that it works. (grin)
John White [MOST]