• ⌂ Math
• Functions
  • ABS()
  • CEIL()
  • CEILING()
  • FLOOR()
  • FORMAT()
  • HEX()
  • OCT()
  • RAND()
  • ROUND()
  • UNHEX()

UNHEX()

 Return a string containing hex representation of a number

Prototype

binary UNHEX(string str)

Parameter

• str - String containing hexadecimal character pairs to be converted to their binary equivelent.

Return

For a string argument str, UNHEX(str) interprets each pair of characters in the argument as a hexadecimal number and converts it to the byte represented by the number. The return value is a binary string.

Example

SELECT UNHEX(HexValue) AS Binary FROM Config

Related

ORD(), HEX()

• < ROUND()
• Text >