question

Chris 2 avatar image
Chris 2 asked

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 comment
10 |1200

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

@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 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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