I have a field in one of my SQL Server tables called 'Categories'. It contains a number of associated items each with a value and separated by a ';'. For example the filed might contain something like the following.
When I query my report I get all of the above listed under a single column caled 'Categories'.
I would like to be able to list each item in the 'Categories' field in its own column. Also, depending upon the report type I would not want to list all the items but only those that might be relevant.