>>>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 ;
>>

>
>Gregory
>I need an aggregate
>

>select;
> Unifier,;
> Sum(Number) as number,;
> AGGREGATE_BITOR(PatternField) as Patterns;
> from ...;
> group by 1
>

>
>Agnes

Agnes,

I see - been thinking - need coffee - no idea for the moment