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.