Thanks for the response on bitwise operators. But I am trying to use the same like this...
Pls find below the queries which worked and which did not work as well.
up to 5 digits the operator works fine and fails for more thatn 5 digits.
-- the logcal operator works fine for a smaller value !
-- the out put is zero
-- the logcal operator works fine for values which are exceeding 5 digits !
-- the out put is non zero
'1000000000000000110000000001100000000000000000000 00000000100001000000000000000000100') hi