mister.magoo (10/8/2013)
I see your problem now - it is the tags in the XML ...try this instead:
DECLARE @PDFFileName VARCHAR(8000) =
(
SELECT ( SELECT PDF_FileName + '.pdf< br/ >'
FROM @PDFResult
ORDER BY 1 ASC FOR XML PATH(''),TYPE).value('.','varchar(8000)')
)
The addition of the TYPE directive and the subsequent ".value" method will prevent the entization of the < br /> tags.
GOT IT!!! both methods worked yours and mine, but yours is a cleaner read....
I didnt work out it was in the HTML till you pointed me in the right direction before about issue being with HTML... mucked around a bit and saw that didnt matter what was being passed it ignored. Yeap the Tags kept getting translated but didnt know what to do with them... everytime i posted it here just kept changing it...
appreciate your help on this!!