alter function f_splitIncrease
(
    @strSource nvarchar(2000),
    @strSplitStr nvarchar(100)
)
returns @tempTable table(id int identity primary key, one nvarchar(1000))
as
begin
    declare @tempStr nvarchar(1000);
    declare @startIndex int;
    set @startIndex = 1;
    set @strSource = @strSource + @strSplitStr;
    while(@startIndex <> 0)
    begin
        set @startIndex = charindex(@strSplitstr, @strSource, @startIndex+1);
        if(@startIndex <> 0)
        begin
            set @tempStr = left(@strSource, @startIndex - 1);
            if(@tempStr <> '')
            begin
                insert into @tempTable values(@tempStr);
            end
        end
    end
return
end

alter proc Proc_Product_Related
(
    @name nvarchar(2000),
    @splitStr nvarchar(100) = ' '
)
as
begin
    declare @tempTable table(
        id int identity(1,1) primary key,
        ProductID int,
        [Name] nvarchar(255),
        ProductNo nvarchar(50),
        MemberPrice money,
        ThumbnailImg nvarchar(255),
        ProductImg nvarchar(255)
    )
    if(@splitStr is Null)
    begin
        set @splitStr = ' ';
    end
    begin transaction
    insert into @tempTable
        select distinct ProductID, [Name], ProductNo, MemberPrice, ThumbnailImg, ProductImg from product p, (select * from dbo.f_splitIncrease(@name, @splitStr)) f 
    where p.name like + f.one + '%'
    if(@@error > 0)
    begin
        rollback transaction
    end
    select * from @tempTable
    if @@error > 0
        rollback
    else
        commit transaction
end