XML Text

In my select statement building my XML file there are records that have

R & B Builders

My select is placing that in my xml as
R & B Builders

How do I get it in there correctly?
	  debtFirstName 'Debtors/Names/IndividualName/FirstName',
	  debtLastName 'Debtors/Names/IndividualName/LastName'
	  research.dbo.r_data_ucc where debtLastName Like 'B%'
for xml path('Record')

Open in new window

Who is Participating?
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
" <, >, & and (in attribute values) " need escaping " in XML because they are used in markup.  &amp; is correct and the code that processes the XML should convert it back if necessary.  That is also the correct encoding to display an ampersand on a web page.
lrbristerAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.