UNHEX

UNHEX returns a character string that is the decoded value of a hex input string.

Read syntax diagramSkip visual syntax diagramUNHEX( x, c)
x
An expression that must have CHARACTER type.
c
An expression that must have CHARACTER(1) NONVARYING type. If specified, it is the character that separates every 8 characters in x.

UNHEX(x) is the reverse of HEX(y), and UNHEX(x, c) is the reverse of HEX(y, c).

If x contains non-hex characters, the CONVERSION condition will be raised.