xml Enclode

[Amit Kumar G]

I am using below sql SELECT CategoryId,CategoryDesc FROM TB_CategoryMaster AS Category WHERE CategoryActive=0 ORDER BY CategoryDisplayOrder FOR XML AUTO, ELEMENTS, TYPE and output comes like ... Buy * Sell instead of Buy and Sell... where * stands for amp How i can handle the same at sql end before sending to client end,,,, Thanks!!