You have two options.

The first is to construct your query using dynamic SQL.

The second option is to convert the array to a table and then JOIN to that table.

The following article explains how to split an array into a table:

http://www.sqlservercentral.com/articles/TSQL/62867/