https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/faking-arrays-in-transact-sql/
It is a simple routine that we all need to use occasionally; parsing a delimited list of strings in TSQL. In a perfect relational world, it isn't necessary,...
transact sqlsimple talkfakingarrays