You can use the undocumented system stored procedure xp_varbintohexstr

DECLARE @id int, @String varchar(32), @Id_vb varbinary(12)
SET @id = 1439
SET  @Id_vb = CAST( @Id AS varbinary(12))
EXEC master..xp_varbintohexstr @id_vb, @string OUTPUT
SELECT @string

>Situation: I have several tables full of integer type configuration information for alarm systems. I have to convert each integer to hex and then I need to concatenate these fields and format them to sent them over the web to the alarm panel. My problem is that I cannot convert varbinary to char, nchar, varchar or nvarchar. I get nothing. I know there is something stupid I'm missing here. Any help would save me from having to calc the hex via math.

< snip >