You can apply CHAR2HEXINT to a string literal to determine its hexadecimal equivalent.
Character literals are treated as VARCHAR(n) CHARACTER SET UNICODE, where n is the length of the literal.
The following statement and results illustrate how CHAR2HEXINT operates on literal strings:
SELECT CHAR2HEXINT('123');
Result:
Char2HexInt('123') ----------------------- 003100320033