Bits of .NET

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