>Hi All,
>
>I have a small problem to aggragate a field.
>
>The field is a integer holding bit patterns.
>
>I like to aggreagte like a BITOR, IOW all bits set should remain.
>
>Any ideas?
>
>Agnes


Any example Agnes ?

You can select something like

select name ;
 (bittest(field, 2) or bittest(field, 4)) as AnotherField ;