SQL Server written in the same industry is similar to the split function.

Create Function f_split (@ sourcesql varchar (8000), @ strseprate varchar (10 ))
Returns @ temp table (A varchar (100 ))
-- Implement the split Function
-- Date: 2005-4-20
-- Author: Domino
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)-@ 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 ',':')

http://blog.csdn.net/great_domino/archive/2005/04/20/355033.aspx