how to check multiple values in a single comma seperated column

Question

I am trying to execute a query in c#,the query as

select Id from employee where name in (@name)

i am try to passing 3 cases

1.@name='sa'
2.@name='as,ab'
3.@name='ad'

and the output am expecting

1.id=1

2.id=2

3.id=3

my table employee value contains ,

You should not store CSV data in a column like that. There should be a separate table with records like `an` and `sa` and then a third table that joins the two tables. — mjwills, Oct 25 '18 at 11:21
`as` and `an` check boxes values so i can select multiple checkbox `as` and `an` so the date saved by table as ,as,an — bob marti, Oct 25 '18 at 11:25
i mean that the issue not realated to database but i connected a db for executing this into c# — bob marti, Oct 25 '18 at 11:33
I would argue it is related to database. Your database model is poor (as per my first comment). — mjwills, Oct 25 '18 at 11:34

score 0 · Answer 1 · answered Oct 25 '18 at 12:10

0

First create user defined split function in DB using this link Then Apply to your table. it would very easy for you.

answered Oct 25 '18 at 12:10

Abuzar Ansari

score -1 · Answer 2 · answered Oct 25 '18 at 11:38

-1

How about the assigning the variable

@name='%sa%'

and then using this below query

 select * from employee where Names LIKE (@name)

answered Oct 25 '18 at 11:38

Sats

2 Answers2