string_split() is a table-valued function that splits a string into rows of substrings, based on a specified separator character.
SELECT * FROM string_split('21;32;34;47;53;61;', ';')
OUTPUT
======
21
32
34
47
53
61
string_split() is a table-valued function that splits a string into rows of substrings, based on a specified separator character.
SELECT * FROM string_split('21;32;34;47;53;61;', ';')
OUTPUT
======
21
32
34
47
53
61