CREATE FUNCTION dbo.Split(@Str Varchar(4000), @Delimiter Varchar(5))
RETURNS @Results TABLE (Items Varchar(4000))
AS BEGIN
    DECLARE @Counter Int = 1, @Slice Varchar(4000);

    IF @Str IS NULL RETURN;

    WHILE @Counter != 0
    BEGIN 
        SELECT @Counter = CHARINDEX(@Delimiter, @Str);
        IF @Counter != 0
            SELECT @Slice = LEFT(@Str, @Counter - 1);
        ELSE
            SELECT @Slice = @Str;

        INSERT INTO @Results(Items) VALUES(@Slice)
        SELECT @Str = RIGHT(@Str, LEN(@Str) - @Counter);
        IF LEN(@Str) = 0 BREAK;
    END;
    RETURN;
END;

SELECT T.*, S.Items
FROM Table1 T, dbo.Split(T.Field1, '*') S