• Sorry, I made a mistake in my post. The string passed into the stored proc doesn't contain the single quotes. It is passed like this "10,11,12"

    That is what the split function is for, it adds in the single quotes so I can use it with th IN operator.