Hex Function

The hex(A) function interprets its argument as a BLOB and returns a string which is the upper-case hexadecimal rendering of the content of that blob. The one parameter A can be Integers whose character values (according to the ASCII table) are to be retrieved.

SELECT hex(67) /* returns : "3637" */;

SELECT hex('SQLDatabase.Net') /* returns : "53514C44617461626173652E4E6574" */;

SELECT hex('A') /* returns : "41" */;