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.
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 a variable it fails to run, I think because of the quotes that surround a string.
Any thoughts? Thanks in advance