How to upper case xml with special character in sql server?

Question

I need to upper case a XML, but the xml could have some special characters like < & " so I replace them in the XML with (<) (&) ("), then when I do the ucase with upper I get this:

XML parsing: line 1, character 387, well formed check: undeclared entity

How can avoid this? so I can ucase my XML?

Parsing xml with Special Characters in SQl Server

Answer 1

XML character entity references must be lower-case. So, you could try upper-casing before encoding the special characters.