HTA() Function – Convert Hexadecimal to ASCII

Syntax

HTA (string)

Description

The HTA() Function returns a human-readable string that is the hexadecimal representation of the string argument. The result will always be twice the length of the argument.

Example

Select HTA(LAST_NAME) from customer