> 3> Chars/varchar fields containing all the words
> <first word> and <second word> ..... <nth word>

Looks like full-text indexing to me. Patil, if you're using the TIBO
components, look at Rubicon. (www.tamaracka.com)

Art Metz
AMetz@...

-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
Sent: Saturday, November 25, 2000 12:03 PM
To: IBObjects@egroups.com
Subject: Re: [IBO] Criterias can be entered into QBE form with IBO


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
>
>
>
>