For 1 and two you can use BETWEEN <aval> AND <aval>

For the third I don't believe it is currently supported. Please suggest how
you propose it could be implemented.

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

----- Original Message -----
From: "R. S. Patil" <rspatil@...>
To: "IB Objects E-Group" <ibobjects@egroups.com>
Sent: Saturday, November 25, 2000 1:04 PM
Subject: [IBO] Criterias can be entered into QBE form with IBO


> Dear Friends,
>
> we r all aware that when a dataset is set into Search mode the IBO
> native controls present QBE form can somebody tell me how to enter range
> criterias for following
>
> 1> Integer fields value > minval and value < maxval
> 2> Date field dates between mindate and maxdate
> 3> Chars/varchar fields containing all the words
> <first word> and <second word> ..... <nth word>
> Field starting with letters > say M i.e. it should show all records
> starting with M,N,...Z
>
>
>
>