Hi Agnes,

Would this work for you?

pnResult = 0

SELECT ..., BITORSQL(myfield) ...

FUNCTION BITORSQL(tnVal)
RETURN BITOR(pnResult , tnVal)

>
>I have a small problem to aggregate a field.
>
>The field is a integer holding bit patterns.
>
>I like to aggregate like a BITOR, IOW all bits set should remain.
>