Thanks everyone!

I ended up just using a temp table and inserting the values into the temp table at the start of my query. I then used WHERE itemCode IN (select...