3.8.2 Relational Operators

You can specify one of the relational operators as described in Table 3-6 below. The relational operator must be the first thing in the field, otherwise it is taken as a part of the field value.

  Table 3-6                                                                

                                                                          

Operator Description                                                       

                                                                          

= Match records with field equal to pattern.                               

 This is the same as an ordinary (not inexact) query                       

                                                                          

                                                                          

!= Match records with field not equal to pattern                           

                                                                          

                                                                          

< Match records with field less than to pattern                          

                                                                          

                                                                          

<= Match records with field less or equal to than pattern                

                                                                          

                                                                          

> Match records with field greater than pattern                          

                                                                          

                                                                          

>= Match records with field greater than or equal to pattern             

                                                                          

If you enter >50000 as a query pattern in the zip field, form will only find records whose zip field is larger than 50000.