Ow Mun Heng wrote:
> Hi Guys,
>
> Searching the net didn't give me much clues as to how to convert a Decimal
> number into BINARY.
>
well, a decimal number is a fixed point number stored in a modified BCD
format, which optionally can contain a decimal fractional component.
you likely would want to convert it to a INTEGER or BIGINT first, then
cats it to BIT(n) where N is the number of bits you want.