>>Yes, it works just fine. However, I don't know too many people who work with 6M strings in memory... a little clumsy.
>
>
>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."