For anyone using SQL Server 2008, there is another option that is extremely efficient and does not require a splitter function:
http://www.sqlservercentral.com/articles/SQL+Server+2008/66554/
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR