Sean Lange (3/14/2014)
Well you first example was using a parameter. Not sure what you mean by an array of strings. How do you get this into sql?You seem to be jumping back and forth between string literals and parameters. Honestly your query doesn't make any sense because you have IN with no parenthesis. Are you passing the whole string including the parenthesis? How are you running this? This really isn't that hard but you aren't providing much detail for me to work with here.
The query is placed in Business Objects. The parameter is also from Business Objects. It's a Multi value parameter that includes parenthesis.
So the @parameter is equal to: ('Value1', 'Value2', 'Value3') --parenthesis included.
So when you use that parameter in a IN statement, it works perfectly. But it seems that it only works exclusively with the IN statement.
Maybe a better example will be the following:
SELECT ('Value1', 'Value2') --This will get an error.
How can you work that query in order to get the following result:
Code
-----------------
'Value1', 'Value2'
(1 row(s) affected)