Categories: Conversion, String, Binary
Converts the hexadecimal number into the bytes represented by a number.
UNHEX(expression varchar) → varbinary
- expression: A string containing only hexadecimal digits.
SELECT UNHEX('4472656D696F') -- RHJlbWlv
The returned value is a binary string. If the expression contains non-hex characters the result is
Was this page helpful?
Glad to hear it! Thank you for your feedback. Sorry to hear that. Thank you for your feedback.