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
Related posts:
Update Column with row_number() in SQL
How to solve "TableAdapter can't see stored procedure returned fields when using temp table" problem
How to check for 'IS NOT NULL' And 'IS NOT EMPTY' string in SQL
Get the User Name and Domain Name from an Email Address in SQL
List all Foreign Keys referencing a given table in SQL Server