sql server - Comma Delimited SQL string Need to separated

Question

I have this string that i am getting from .net application A,B,C,D,E,F,

I wanted to write a sql select statement like

set @string = 'A,B,C,D,E,F'

select * from tbl_test 
where tbl_test.code in (@string)

This wont work in t-SQL because it is using the @string as one string it is not separating the values. Is there any ways i can do this?

Answer 1

3 options

1. Use a regular expression to replace the "," with "','" so that it becomes a proper ('A','B'...) list
2. Convert the list to XML and then parse the XML in your SELECT
3. Write a SPLIT function to convert comma delimited lists to tables