SQL: Perfect cuts with SPLIT (EN)

Last Updated on 13 June 2021 by Roberto De Pedrini Starting with IBM’s TR6 i 7.3, there is a new function that allows a string that contains values separated by a specific separator character to be subdivided into substrings. The SPLIT() function returns a table in which each row contains a single substring whose base string is composed. The syntax is: SPLIT ( expression , separator ) Where expression contains an alphanumeric value, and separator is the character that splits the portions of the string. Only a single separator character can be indicated. …