Posts by Raymann • 33 points

• 1

  votes

  1

  answer

  456

  views

  A: Extract xml tag from a varchar(max) column

  I got the answer, it worked like this: select SUBSTRING (@coluna,CHARINDEX('<MT_USADA>', @coluna)+LEN('<MT_USADA>'),(CHARINDEX('</MT_USADA>',…

  sql sql-server select-sql

  answered 6 years, 3 months ago Raymann 33

• 2

  votes

  1

  answer

  456

  views

  Q: Extract xml tag from a varchar(max) column

  Hello, I have a series of xml records in a varchar(max) column and need to extract the tag <MT_USADA>16 MB</MT_USADA>, for example: <?xml version="1.0" encoding="utf-8"?>…

  sql sql-server select-sql

  asked 6 years, 3 months ago Raymann 33