what is the syntax for using IN for filtering data with TIB_Edit

--- In IBObjects@y..., Geoff Worboys <geoff@t...> wrote:
> > But I would like to know, what are the other options and if the
user
> > can enter coumpound condition like "(>10 and <100) or (>1000)".
>
> Unless Jason has added something recently there is no support for OR
> statements when searching in IB_Edit.
>
> Other than using =, >, < etc operators you can also use all the
> various sql operators...
>
> between
> containing
> in
> is null
> is not null
> like
> not like
> not starting
> not containing
> not in
> not between
> starting
>
> I think that about covers it.
>
> --
> Geoff Worboys
> Telesis Computing