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



______________________________________________________________________________________

Copyright BASIS International Ltd. BBj®, Visual PRO/5®, PRO/5®, and BBx® are registered trademarks.