MAXRECURSION cannot be used on UDFs. This is limited by the default MAXRECURSION value of 100 as it was mentioned above.

The WHILE methods are not the best performers either, using a table of numbers is. Find some examples here: http://stackoverflow.com/questions/753582/implementing-and-applying-a-string-split-in-t-sql