sql array varchar code example

Example: accessing varchar array from sql

SELECT ...
FROM   tbl 
WHERE  col IN (SELECT convert(int, value) FROM string_split('1,2,3,4', ','))