March 7th, 2013, 04:13 AM
AND All BIN Rows
I was hope to be able to move part of my code into the DB, but I am not sure if it is possible.
If I do
SELECT BIN(Small Int Column) FROM table
then I get a list of BIN values
Is there a function like SUM for decimal numbers, but for binary that will AND the rows together and give one value
I mean if for example if i Have
Is there a function like
SELECT AND(BIN(column)) and in the case above it would return 011 as it is the AND value of all the rows returned
March 7th, 2013, 05:03 AM
i don't think there is an aggregate AND function, sorry
too bad you decided to use binary
any chance you can change it?