Was playing with STRING_SPLIT function the other day in my Azure SQL database instance and happened to notice a small enhancement which seems to have appeared. The STRING_SPLIT function now includes a new optional parameter which can be used for…
Parsing a delimited string
Most often I’ve seen posts where the requirement is to parse a delimited string and convert it to table of values. Below is a table valued function which I use to parse a delimited string and convert it to table…