Your input BatchNo Range is invalid!!select BatchNo from batchinfo WHERE (BatchNo <= " ") ORDER BY BatchNo