How can dbman hit numbers >5 and <7 from a list like 1,2,3,4,5,6,7,8,9?
The results should be 5,6 and 7.
THANKS

If you want the results to be 5,6,7, you'll have to use > 4 and < 8.

------------------
JPD

Sorry for the wrong example, but my question was about the syntax. If I use a query like = >4 <8 oder = >4 and <8. I only get the results from >4 ( 5,6,7,8,9)instead of 5,6,7.


------------------

First of all, you can't enter

= > 4

it won't recognize the = sign.

You also can't enter

> 4 < 8

in one field. You need two fields.

> 4

< 8

Or, if you are likely to want to do many of this type of search, you might just use "-lt" and "-gt" fields--

<TR><TD>Greater than:</TD>
<TD><input type="text" name="FieldName-gt"></TD>
<TR><TD>Less than:</TD>
<TD><input type="text" name="FieldName-lt"></TD>


------------------
JPD

You can't use >4 and <8 at once. You'll need to switch to the -gt and -lt syntax like JPD suggests. It's the only way to do a range search, the > and < can only be used for doing a greater then or less then search, but not both.

Cheers,

Alex