Adding Text to and XML Field 1

[grnzbra]

I have a table with an XML field in which many of the XML entries don't have the <?xml version="1.0" encoding="utf-8"?> prefix. How would I write an update statement to tack that onto the front of the XML statement? The error I get is "The data types varchar and xml are incompatible in the add operator.

 

[Andrzejek]

You can try to Use a LIKE statement on SQL Server XML Datatype

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[grnzbra]

Thank you. That was a big help.