Make categories a valid JSON object. Much easier to use JSON option SQL Server 2016. See functionality SQL Server 2016 for JSON. I want to set categories in Highcharts like so:

categories: [{"name":"apples"},{"name":"bananas"},{"name":"kiwis"}]

Or something else for 'name'. Now I have to use a trick with XML and STUFF to get it like ["apples", "bananas","kiwis"].