Can we do bitwise andfirebird in a procedure without using UDF? is there one of the built-in functions here or is there a way to get the same results with standard built-in commands?
bitwise and
I tried http://www.firebirdsql.org/refdocs/langrefupd21-intfunc-bin_and.html (BIN_AND), but I need some implementation without UDF.
Ex: (3 & 3) returns 3in SQL, but not in firebird (firebird 2.1).
(3 & 3) returns 3
Firebird has no bitwise operators; function BIN_AND()is the way to go. Since the functions of Firebird 2.1, those BIN_*are internal functions , that is, they are always available without any external DLL or register them as UDF.
BIN_AND()
BIN_*
tag - c #