question

Chris 2 asked Sep 30, '17

How to convert '>' in xml?

Hi, On Windows 2008R2/SQL 2012, T-SQL to xml. A column has 'Store >> Seattle'. Tried REPLACE(column, '>', '>') to have readable '>' but no good. Did I miss something? Thanks.

mssql2012

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Oleg commented · Oct 01, 2017 at 02:26 AM

@Chris 2 It is hard to understand what is the problem, but it looks like the arguments are flipped. If the varchar column has **Store >> Seattle** in it then to convert it to a valid XML the replace has to read REPLACE(column, '>', '>') doesn't it?

0 ·