UDF that gets a delimited string and returns a table variable with the values of the string as rows

Parse Delimited Strings

CREATE Function [dbo].[fn_ParseDelimitedStrings]
(
@String nvarchar(max), 
@Delimiter char(1)
)
Returns @Values Table 
(
	RowId int Not Null Identity(1,1) Primary Key,
	Value nvarchar(3000) Not Null
)
As
Begin
	Declare @startPos smallint,@endPos smallint
	If (Right(@String, 1) != @Delimiter)
		Set @String = @String + @Delimiter
		Set @startPos = 1
		Set @endPos = CharIndex(@Delimiter, @String)
		While @endPos > 0
		 Begin
			Insert @Values(Value)
			Select LTrim(RTrim(SubString(@String, @startPos, @endPos - @startPos)))
			-- remove the delimiter just used
			Set @String = Stuff(@String, @endPos, 1, '')
			-- move string pointer to next delimiter
			Set @startPos = @endPos
			Set @endPos = CharIndex(@Delimiter, @String)
		End
		Return
End