Using table-valued functions to split strings in a database

New table-valued Function:

Create function [dbo]. [F_split] (@SourceSql varchar (8000), @StrSeprate varchar (Ten)) Returns @temp table (a varchar ( -)) asBEGIN DECLARE @iint    Set@SourceSql =RTrim (LTrim (@SourceSql))Set@i=charindex (@StrSeprate, @SourceSql) while@i>=1begin insert @temp values (left (@SourceSql, @i-1))        Set@SourceSql =substring (@SourceSql, @i+1, Len (@SourceSql)-@i)Set@i=charindex (@StrSeprate, @SourceSql) Endif@SourceSql <>'\ 'Insert @temp VALUES (@SourceSql)returnEnd

Example:

Select From F_split ('A-st', ',') 

Results:

Using table-valued functions to split strings in a database