>>>>Yeah it would be fast if it worked:) Try Jeff Moden's code instead (I gave a link before).
>>>>
>>>
>>>Do you mean you want it for more than 8000 chars or more than 100 max recursion?
>>
>>Yeah, pick whichever you want.
>>Cetin
>
>Yes, in this case we need to use varchar(max) as a parameter and maxrecursion = 0 (no limit)
>
>See
http://smehrozalam.wordpress.com/2009/06/09/t-sql-using-common-table-expressions-cte-to-generate-sequences/>
>Can you post both versions of the split function code and your tests results in terms of speed / query plan?
>
>See for more discussion here
http://forum.lessthandot.com/viewtopic.php?f=17&t=7566&st=0&sk=t&sd=aNo I don't think that you should need to adjust maxrecursion yourself (and if there is a non recursion alternative I would prefer).
If you search for Jeff Moden here you would find the sample (I don't know why 'copy' didn't work this time.
Cetin