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 @str =

'line1

line2

line3

line4'

SELECT...