Daily Archive: November 8, 2021

Ordered string splitting in SQL Server with OPENJSON

Every time I write a post about splitting strings, I promise myself it's the last one. I need to stop making that promise. In this tip, I show how I compared my previous favorite ordered splitting function to a different technique using OPENJSON().