>Hi Walter,
>
>as I understand your method mades double bytes out of both strings shift the second 8 bits right and bit connect them?
>
>The problem is that I not see how this will work with 10 strings ...


Hi agnes,


You're right... 2, 4 or 8 is easy to do (1, 2 or 3 times a STRCONV()) function, but anything not being a power of 2 is not possible this way. If speed is a concern, you might choose this method for 2, 4 and 8 strings, but for 6 and 10 choose the earlier (but slower) solution


Walter


>Agnes
>>Hi Agnes,
>>
>>A total different approach to this problem:
>>
>>The following is about 10 times as fast for two strings as the earlier solution, however handling more than two strings needs some additonal logic (process them in pairs and process the result of that again)
>>
>>

>>cStr1 = "ABCDEFGHIJ"
>>cStr2 = "0123456789"
>>
>>cResult = CAST(BITOR(CAST(STRCONV(cStr1,12) as W),SUBSTR(CAST(STRCONV(' '+cStr2,12) as W),2)) as C(LEN(cStr1)*2))
>>