BIN() — Returns the binary representation of a BIGINT value as a string.

BIN( *value* )

The BIN() function returns the binary representation of a BIGINT value as a string. The function will return the shortest valid string representation, truncating any preceding zeros (except in the case of the value zero, which is returned as the string "0").

The following example use the BIN and BITAND functions to return the binary representations of two BIGINT values and their binary intersection.

$ sqlcmd 1> create table bits (a bigint, b bigint); 2> insert into bits values(55,99); 3> select bin(a) as int1, bin(b) as int2, 4> bin(bitand(a,b)) as intersection from bits; INT1 INT2 INTERSECTION -------- --------- ------------- 110111 1100011 100011