@BINTOHEX

Use the @BINTOHEX function to convert supplied binary data into its hexadecimal equivalent.

Syntax

@BINTOHEX (<data>)

<data>

Can be one of the following:

• The name of the source column that contains the data

• An expression

• A literal string that is enclosed within single quote marks

Example

@BINTOHEX ('12345') converts to 3132333435.