====== SQL Value as Hex ======

To get a hex representation of a value the SQL function [[https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_73/db2/rbafzscahex.htm | hex]] can be used:

<sxh sql>
select hex('MIHAEL') from sysibm.sysdummy1
</sxh>

{{tag>devel sql ibm}}