SELECT * FROM Products_Table WHERE prod_id >= 1000 AND prod_id <= 1999