I have an issue, i am selecting something in SQL Server which gives me a value of this:
web_Day_3_Windsor (Boxing Day)
This is an example of the type of query i am using:
SELECT Name as name
FOR XML PATH('item')
Now what i wanted to know is that if there is a way to display the result as:
Thats perfect, thanks.
Has been a long time since i've posted on this forum as i got a new job. But will be posting on here more often.