put along a split string in sql waiter function

build feature [dbo]. [f_split] (@ c varchar (2000),GHD IV Straighteners, @ split varchar (2))
returns @ t table (column varchar (20))
as
begin
when (charindex (@ split, @ c) 0)
begin
insert @ t (col) amounts ​​(substring (@ c,GHD Midnight Gift Set 2011, 1,GHD MK4 Pure Straighteners, charindex (@ split,GHD IV Salon Straighteners, @ c) -1))
set @ c = matter (@ c, 1,GHD Red Straighteners, charindex (@ split,GHD Green Straighteners, @ c ),'')
end
insert @ t (col) values ​​(@ c)
return
end