SQL Server/T-SQL Tutorial/System Functions/fn varbintohexsubstring
Invoking the fn_varbintohexsubstring() Scalar Function
<source lang="sql">
4> 5> SELECT 6> master.dbo.fn_varbintohexsubstring(1, 0x0123456789abcdef, 1, 2) 7> GO
0x0123
(1 rows affected)</source>