A: 

HI ALL... I solved this problem. I was using string for BETWEEN clause, since upper limit and lower limit should be in numeric type. and so its working. But thanks for your help.

sid