User Answers

Aditi,

 

Two thoughts.. 

 

Firstly, you say A is defined as Integer - my experience shows, in cases where the data is seen as a "string" using ".. A>=12345*1 and A<=12390*1.." will ensure the 'numeric' values are used so a 'numeric' rather than 'character' comparison is performed 
Second, adding " order by A*1" on the end of the query will ensure that you see the list in actual numerically sorted order and unlikely to miss some values

 

Just a thought..

 

Rosti.