I don't know of any built in function but there are a number of user defined functions mentioned on this site and in the faq that parse a delimited list and return a "table". Here's one: http://qa.sqlservercentral.com/scripts/contributions/319.asp
It will allow you to pass a delimited list to the function and you can select from the resulting table like: