UNHEX

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

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.