Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding Text to and XML Field 1

Status
Not open for further replies.

grnzbra

Programmer
Mar 12, 2002
1,273
0
0
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top