CDATA Set with For XML Explicit
Just a question I have been pondering for a while. Is there any way to wrap column data in a CDATA set and still have it use the column name as value. So far I haven't been able to do so (without resorting to put CDATA as hardcoded text around the value) and was curious if anyone else has done so. If yes could you please send a sample of a query or explain how its done?