SQL Split string

Create function [dbo]. [Fn_split]
(
@SourceSql nvarchar (max),--source delimited string
@StrSeprate varchar (10)--delimiter
)
Returns @temp table (a nvarchar (max))
As
Begin
DECLARE @i int
Set @SourceSql =rtrim (LTrim (@SourceSql))
Set @i=charindex (@StrSeprate, @SourceSql)
While @i>=1
Begin
Insert @temp values (left (@SourceSql, @i-1))
Set @SourceSql =substring (@SourceSql, @i+1,len (@SourceSql) [email protected]
Set @i=charindex (@StrSeprate, @SourceSql)
End
If @SourceSql <> ' \ '
Insert @temp VALUES (@SourceSql)
Return
End
Go