HEXTORAW
The HEXTORAW function returns a binary string representation of a character string that has been formatted using a format-string.
The HEXTORAW function is identical to VARBINARY_FORMAT except that if the length of expression is an odd number of characters, the string is padded on the left with one '0' character. For more information, see VARBINARY_FORMAT.