VARBINARY_TO_VARCHAR

VARBINARY_TO_VARCHAR(sourceBytes VARBINARY(65535))
RETURNS VARCHAR(65535)

This function converts a VARBINARY value into the corresponding hex-encoded binary string. For example, this converts the byte array [1,2,3,4] into the string ‘01020304’.

The VARCHAR type is similar to the VARBINARY type, but it stores character strings instead of binary byte strings. For more details on s-Server’s data types, see the topic SQLstream Data Types.

The inverse operation is VARCHAR_TO_VARBINARY().