>>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
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]