How to use Sql Between in Progress

Posted by elhacker777 on 06-May-2013 10:38

Hi all friends, Please let me know how to use Between for example in the following query

Select * from Table where  cant   between '500' and '1500'

Greetings.

Mitchell

All Replies

Posted by robw@hltool.com on 06-May-2013 10:52

> Select * from Table where  cant   between '500' and '1500'

For Each Table where

     cant > 500 and

     cant

     display Table with 3 col.

end.

is one way to do it.

This thread is closed