Posted on: July 21, 2020 Posted by: Gary Dawson Comments: 0

Splitting a String with SQL

There are times when writing a custom report, that a string is returned and you will want to bust up the string and process each value individually. With SQL Server 2016, you can simply use the built-in function “split_string”.

For SQL Server databases prior to SQL Server 2016, you have to get creative. There are many ways to accomplish the same end result, however, Yardi has built a function to achieve this.

Splitting a String with SQL was last modified: February 10th, 2021 by Gary Dawson