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.