i can't find split or an equivalent for tokenizing strings in t-sql, is there one?

Ref. Link:

http://msdn.microsoft.com/library/de...atYourself.asp

Hi,
If you're looking for a split function for sql, I'm using the dbo.split udf that you can find codes at http://www.kodyaz.com/forums/thread/489.aspx

You can use the dbo.split function like

select * from dbo.SPLIT('A udf for splitting strings',SPACE(1))

Here is a more efficient way to split a string, since there are no string handling (reallocate new memory for each iteration)
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76033

Hello,

I have created a sql function for splitting string values using recursive CTE's for SQL2005 and later.
You can find the t-sql codes for this split function at SQL Server 2005 T-SQL Recursive Split Function

This might be an alternative to existing string manipulating sql functions.

Eralper
http://www.kodyaz.com