Hi,

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

select bitand
('10100',
'00001') hi
from dual

-- the logcal operator works fine for values which are exceeding 5 digits !
-- the out put is non zero

select bitand
('001000',
'100011') hi
from dual

select bitand
('001000000000000000000010000000010000000000010000 000000000000000000000010000000000000',
'1000000000000000110000000001100000000000000000000 00000000100001000000000000000000100') hi
from dual

Thanks