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?
blah...blah...blah...
	  debtFirstName 'Debtors/Names/IndividualName/FirstName',
	  debtLastName 'Debtors/Names/IndividualName/LastName'
from
	  research.dbo.r_data_ucc where debtLastName Like 'B%'
for xml path('Record')

Open in new window

Larry Bristersr. DeveloperAsked:
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.
0
 
Larry Bristersr. DeveloperAuthor Commented:
Thanks
0
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.