Purpose
Returns a bit string that is the logical OR of the elements of a bit string array.
Parameters
x is an array expression. If x is not a bit string array, it is converted to one.
Examples
DECLARE BIT_TEST(3) BIT(5) INITIAL ('10011'B, '10111'B, 10110'B);
DECLARE BIT_RES BIT(5);
BIT_RES = ANY(BIT_TEST); /* returns '10111'B */
Description
The ANY function returns a bit string whose length is equal to the length of the longest bit string value in the array. Each bit of the result is 1 if the corresponding bit exists and has the value 1 in any element of the array.