STRING_SPLIT function represented by user-created function, for databases with lower compatibility level

STRING_SPLIT.sql

CREATE FUNCTION [dbo].[StringSplit] (
	@stringToSplit NVARCHAR(MAX),
	@splitCharacter NVARCHAR(1)
)
RETURNS
 @returnList TABLE ([Name] [nvarchar] (500))
AS
BEGIN

 DECLARE @name NVARCHAR(255)
 DECLARE @pos INT
 DECLARE @NewString nvarchar(max)

 SELECT @NewString = (SELECT REPLACE(@stringToSplit,' ',''))
 WHILE CHARINDEX(@splitCharacter, @NewString) > 0
 BEGIN
  SELECT @pos  = CHARINDEX(@splitCharacter, @NewString)  
  SELECT @name = SUBSTRING(@NewString, 1, @pos-1)

  INSERT INTO @returnList 
  SELECT @name

  SELECT @NewString = SUBSTRING(@NewString, @pos+1, LEN(@NewString)-@pos)
 END

 INSERT INTO @returnList
 SELECT @NewString

 RETURN
END