You have to use the BETWEEN <Aval> AND <AVal> structure.
You can also use IN( <aval>, <aval>, ... ) as well.

There is no logical combining multiple expressions in the search criteria
unless you enhance the built-in parsing using the provided events.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, October 21, 2002 5:56 AM
Subject: Re: [IBO] Using multiple critearia in search panel


At 03:56 PM 21-10-02 +0300, Çaðatay Tengiz wrote:
>Is it possible to use multiple search criteria in search panel edit boxes
>etc. like
>
> >100 AND <200
>
>which will be converted to
>
>where ATABLE.ACOLUMN > 100 and ATABLE.ACOLUMN < 200

Yes.

Helen