why char(13)+char(10) in for xml path('') does not work?

Viewed 2368

when I use char(13)+char(10) in my queries it works, but when I use char(13)+char(10) in a query which has for xml path('') it does not work and instead of that I get this character 
 I think it is because of two for xml path('') although it may not. what should I do?

there is a sample of my code:

select d.title+char(13)+char(10)+
(
   select c.title+char(13)+char(10)+
   (
      select a.title+b.title+char(13)+char(10)
      from tbl_one a
      inner join tbl_two b on a.id=b.one
      where a.id=aa.id
      for xml path('')
   )
   from tbl_one aa on 
   inner join tbl_three c on aa.id=c.one
   where aa.id=aaa.id
   for xml path('')
)
from tbl_four d
inner join tbl_one aaa on d.one=aaa.id
1 Answers
Related