Home Forums Article Discussions Article Discussions by Author Discuss content posted by Kshitij Satpute Fastest way to split delimited string in SQL Server RE: Fastest way to split delimited string in SQL Server
Jason Wolfkill
SSCrazy Eights
Points: 9832
More actions
August 14, 2013 at 9:10 am
#1641452
Check out Jeff Moden's article "Tally OH! An Improved SQL 8K 'CSV Splitter' Function"[/url], which explains a method of splitting delimited strings that outperforms the XML method for strings up to 8000 ASCII characters or 4000 Unicode characters.