There are no arrays in SQL Server.
You can use the character string to store the comma-separated values and then
use PATINDEX function to extract the values, or you can store the values in
separate table.