sql, asp

<i><b>Originally posted by : VIMAL BISHT (vimal_bisht@yahoo.com)</b></i><br /><br />dear fellows,<br /><br />I am developing the search on the asp first time. Now for the connection with the database i am using<br />msaccess database. <br /><br />My problem is that if i want to display the result from the particular price column and want to take the range<br />such as 10$ to 40$ then what sql statement will be needed. <br />e.g. SELECT * FROM TABLE_NAME WHERE PRICE (10-40)$ // THIS IS WRONG STATEMENT.<br /><br />Please tell me the right way.<br /><br />thanks and regards<br />

<i><b>Originally posted by : uday (kuday99@mailcity.com)</b></i><br />dear fellow<br /><br /> use where price between x and y in your SQL statement<br /><br /><br /><br /><br /><br />------------<br />VIMAL BISHT at 4/27/2000 4:11:00 PM<br /><br /><br />dear fellows,<br /><br />I am developing the search on the asp first time. Now for the connection with the database i am using<br />msaccess database. <br /><br />My problem is that if i want to display the result from the particular price column and want to take the range<br />such as 10$ to 40$ then what sql statement will be needed. <br />e.g. SELECT * FROM TABLE_NAME WHERE PRICE (10-40)$ // THIS IS WRONG STATEMENT.<br /><br />Please tell me the right way.<br /><br />thanks and regards<br /><br /><br /><br /><br />