4500RE: UPDATE question
- Apr 6, 2010First thanks again to all for the suggestions on the UPDATE query
yesterday. Works like a charm. But another small problem has popped up and
I think this is in SQL Server.
One of the fields I hit with my subqueries in the UPDATE is a Name column
(vendors) and some of the names have the '&' sign in them such as
John & Warner, Inc
SELECT Vendor_or_Mfg + ', ' as 'data()'
FROM [Table_4(Vendor_or_Mfg)] t4
FOR XML PATH('')) Vendor_or_Mfg
I get John & Warner, Inc
I need the & but not the amp. I know the XML is doing this, anyway to make
it 'stop' or a simple way without a cursor to pass through the rows
returned and replace & with just &? Set preferred to procedural process
is what I'm after.
- << Previous post in topic Next post in topic >>