Since this functionality is very common for us, we use a recursive CTE to handle it. We'll pass in the string (and optionally a delimiter character), and we'll get back a table of values. The value that this option provides is not being restricted
on the number of delimiters in the string. Let me know if you'd like a code snip for it.

Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.