CREATE FUNCTION [dbo].[str2row]	(
	@RowData NVARCHAR(MAX)
	,@SplitOn NVARCHAR(5) )
RETURNS @ReturnValue TABLE ( Data NVARCHAR(MAX) )
AS
BEGIN
	DECLARE	@Counter INT           = 1
		,@MyData     NVARCHAR(MAX)

	IF NOT (@SplitOn = CHAR(13) + CHAR(10) OR @SplitOn = CHAR(13) OR @SplitOn = CHAR(10))
	BEGIN
		SET @RowData = REPLACE(@RowData, CHAR(13), '');
		SET @RowData = REPLACE(@RowData, CHAR(10), '');
	END
	ELSE
		IF @SplitOn = CHAR(10)
			SET @RowData = REPLACE(@RowData, CHAR(13), '');
		ELSE
			IF @SplitOn = CHAR(13)
				SET @RowData = REPLACE(@RowData, CHAR(10), '');

	IF LTRIM(RTRIM(@RowData)) <> ''
	BEGIN
		WHILE (Charindex(@SplitOn, @RowData) > 0)
		BEGIN
			SET @MyData = LTRIM(RTRIM(Substring(@RowData, 1, PATINDEX('%' + @SplitOn + '%', @RowData) - 1)))
			/* ' Entfernen */
			IF LEFT(@MyData, 1)='''' AND RIGHT(@MyData, 1)=''''
			BEGIN
				SET @MyData = Substring(@MyData, 2, LEN(@MyData) - 2)
			END

			IF LTRIM(@MyData) <> ''
				INSERT INTO @ReturnValue ( data )
				SELECT	Data = @MyData;

			SET @RowData = Substring(@RowData, PATINDEX('%' + @SplitOn + '%', @RowData) + LEN(@SplitOn) , LEN(@RowData))

			SET @Counter += 1
		END

		SET @MyData = LTRIM(RTRIM(@RowData))

		IF LEFT(@MyData, 1)='''' AND RIGHT(@MyData, 1)=''''
		BEGIN
			SET @MyData = Substring(@MyData, 2, LEN(@MyData) - 2)
		END

		IF LTRIM(@MyData) <> ''
			INSERT INTO @ReturnValue ( data )
			SELECT	Data = @MyData;
	END

	RETURN
END