Why don't you just not change it. In an "IN" statement you could have zeros and you should just not get any rows back.
USE Northwind
SELECT * from Employees WHERE EmployeeID IN(1,4,0,0)
this is a valid statement, requires no extra vb processing and allows sql to process it and you...