Ex query: Select col1,col12 from Table where col1 in (‘test1’,‘test2’,‘test3’)
when I tried to pass a single value(‘test1’) as a string it’s worked fine. but when I pass multiple strings to the parameter like (‘test1,test2,test3’) for some reason it’s considering as a single string.
is there a way to pass multiple strings ‘IN’ queries?
Query: Select col1,col12 from Table where col1 in (@str_Parameter)
Could some help me with the above query syntax?