davey
  • Member for 9 years, 3 months
  • Last seen more than a month ago
SQL concatenate VARCHAR + VARBINARY with VARBINARY as hex
Accepted answer
3 votes

this is what i wanted to do DECLARE @test VARCHAR(50) = 'Hello World!' DECLARE @testvb VARBINARY(256) SET @testvb = CAST(@test AS VARBINARY(256)); SELECT @test + CONVERT(VARCHAR(MAX),@testvb,2); ...

View answer