I used this function with data pasted from a column or data from excel. Short of some additional error checking it is a handy techique:

declare @STR varchar(max)

select