[cloayza]

Tambien podria ser:

Código Delphi [-]
SELECT * FROM LOTES_SALIDA
WHERE   LOTES_SALIDA.LOTE IN ('100009','100010','..')
ORDER BY LOTE

Saludos