Wrote a split function in SQL Server.

server|sqlserver| function
A function similar to split was written in SQL Server this morning, as required by query statistics, as follows

Create function F_split (@SourceSql varchar (8000), @StrSeprate varchar) returns @temp table (a varchar (100))--    function--date:2005-4-20--author for split function:D OMINOAS begin declare @i int set @SourceSql =rtrim (LTrim (@SourceSql))        Set @i=charindex (@StrSeprate, @SourceSql) while @i>=1 begin inserts @temp values (left (@SourceSql, @i-1))    Set @SourceSql =substring (@SourceSql, @i+1,len (@SourceSql)-@i) set @i=charindex (@StrSeprate, @SourceSql) end If @SourceSql <> ' Insert @temp values (@SourceSql) return end

Usage: SELECT * from Dbo.f_split (' A:b:c:d:e ', ': ')