Hex to String

• EjSQLme

  SSCrazy

  Points: 2172

  More actions

  August 12, 2010 at 3:20 pm

  #226023

  Hi,

  I have SQL 2008 Express version and in one of the table there is a hex value data. If the data is converted to string it displays some type of description in string. For example, the hex code: -536805679 converted should read: Incorrect Function. I tried the scripts below, but it didn't work. Any idea?

  CAST( HexVal AS nvarchar(127)) AS HexErrorCode,

  cast(cast(HexVal as varbinary(max)) as nvarchar(max)) ,

  CONVERT(VARCHAR(8), HexVal ),

  Thanks in advance,

• Lowell

  SSC Guru

  Points: 323482

  More actions

  August 12, 2010 at 5:22 pm

  #1206362

  Declare @cmds Nvarchar(MAX)

  Declare @obfoo varbinary(MAX)

  Set @cmds = '

  PRINT ''This binary string will execute "SELECT * FROM SYS.OBJECTS":''

  SELECT * FROM SYS.OBJECTS

  '

  Set @obfoo = CAST(@cmds as varbinary(MAX))

  Select @obfoo

  select '

  declare @_ as varbinary(max)

  set @_ =' + sys.fn_varbintohexstr(@obfoo) + '

  exec (@_)'

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!