Convert CHAR expression to Binary output (SQL syntax)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • samopal
    New Member
    • Mar 2013
    • 1

    Convert CHAR expression to Binary output (SQL syntax)

    I have an existing table with column MY_BYTE Char(2) which has byte values (like 08, A4, FF...)
    I need to create a SQL which will give me BIT representation of MY_BYTE column (11111111 for FF, 00000111 for 08, etc.)
    Looking for your advice.
Working...