SQL Server split a delimited string into a table

CREATE FUNCTION dbo.splitstring ( @stringToSplit VARCHAR(MAX) )
RETURNS 
 @returnList TABLE ([Name] [nvarchar] (24))
AS
BEGIN

 DECLARE @name NVARCHAR(255)
 DECLARE @pos INT
 
 WHILE CHARINDEX(',', @stringToSplit) > 0
 BEGIN
  SELECT @pos  = CHARINDEX(',', @stringToSplit)  
  SELECT @name = SUBSTRING(@stringToSplit, 1, @pos-1)
  
  INSERT INTO @returnList 
  SELECT @name
  
  SELECT @stringToSplit = SUBSTRING(@stringToSplit, @pos+1, LEN(@stringToSplit)-@pos)
 END

 RETURN
END

Usage:-

SELECT * FROM dbo.splitstring('91,12,65,78,56,789')

Returns:-

91
12
65
78
56