select master.dbo.fn_varbintohexstr( 234 )

declare @i int, @res varchar( 100 )
set @res = ''
set @i =  237814 
while @i> 0 
begin
select @res = case @i % 16  
         when  0  then '0'
         when  1  then '1'
         when  2  then '2'
         when  3  then '3'
         when  4  then '4'
         when  5  then '5'
         when  6  then '6'
         when  7  then '7'
         when  8  then '8'
         when  9  then '9'
         when  10  then 'A'
         when  11  then 'B'
         when  12  then 'C'
         when  13  then 'D'
         when  14  then 'E'
         when  15  then 'F'
end + @res
set @i = @i /  16 
end
select '0x' + @res