select query

Question

Hello ;

 

I have a table:  billTable

 

ID    BillNo     Amount

 

1      A1             1000

2      A5             1500

3      A6             1800

 

I need to select Amount between A4 and A8.

 

Please Help..