Execute query with Select query with parameters

[rkrama04]

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?

Parameter: str_Parameter='test1,test2,test3"
Query: Select col1,col12 from Table where col1 in (@str_Parameter)

Could some help me with the above query syntax?

[postwick (Paul Ostwick)]

It’s considered a single string because it IS a single string.

This is a single string: “test1, test2, test3”

This is three strings: “test1”, “test2”, “test3”

[ermanoj3101 (MANOJ)]

@rkrama04

test1,test2,test3

Hi @rkrama04 ,

Try “'”+test1 + “'” + “,” + “'” + test2 + “'” + “,” + “'” +test3 +“'”

[J0ska]

In case you are reffering to MS SQL/T-SQL then using parameter in IN clause is not supported.

See also How do I use a variable in an IN clause? | SQL Studies

Cheers

[J0ska]

And also here:

SQL String Parameter Issues

I have posted on the forum about this issue before but I am still looking for help. I am trying to pass a list of strings into a query and use the “IN” clause in SQL to go through the list. However, since I am passing a string in, the quotes around the string seem to be causing an issue for the query. [image] For example, WFIDString would be (‘0000000’ , ‘1111111’ , ‘2222222’). When I run the query without the variable/parameter, this query works great. But when I try to pass the string in as…

Cheers

[ermanoj3101 (MANOJ)]

@rkrama04 , Is it worked ?