Results 1 to 1 of 1
Mar 3, 2009, 07:08 #1
T-SQL/MSSQL convert charcters for XML
I have some text in a MSSQL database which contains characters such as &>< etc. I am using T_SQL to create some xml from the information contained within the database.
Does anyone know how to convert the characters to their entities i.e. > become > and & becomes & ?
monkeymonkey - the rest is history