FILTER HELP
~~~~~~~~~~~
 The filter option is the one on the far right of the control panel.


 FILTER  Allows you to pick and display certain records , depending on
       certain conditions.  For example if you had a file of peoples
       addresses and one of the fields was postcode.
       To find all the people in the Walsall area , you would :-

       Make sure nothing is highlighted. (If it is click on CLEAR)
       Click on the POSTCODE field so it is highlighted.
       Click on the LIKE expression so it is highlighted.
       Type in the following :-  WS*      and press RETURN
       Then click on OK.

       All the postcodes that begin with the letters WS will be
       filtered out and displayed in the filter viewing mode.
       (See Filter Display)

       Taking the same example as above , but if all the people with
       a Walsall POSTCODE AND with a SURNAME begin with the letters
       F through to S you would do the following.

       Make sure nothing is highlighted. (If it is click on CLEAR)
       Click on the POSTCODE field so it is highlighted.
       Click on the LIKE expression so it is highlighted.
       Type in the following :- WS*      and press RETURN
       Click on the AND logical expression so it is highlighted.
       Click on the SURNAME field so it is highlighted.
       Click on the LIKE expression so it is highlighted.
       Type in the following :- [F-S]*
       Click on OK.

       The LIKE expression is an extremely powerful part of the
       PowerBase filter options. The following are acceptable special
       characters for use in with this option :-

       *      Any number of preceding or following characters.
              i.e   *S  would find all the enteries in that field that
                    end with an S.

                    *EN* would find all the enteries that contain EN.

                    F* would find all the enteries that start with an F.

       ?      Must be same number of characters.
              i.e   ???N??K? would find all the enteries where the 4th
                    letter is an N , the 7th is a K and the length must
                    be 8 chrs. This would find the name RENNOCKS.

       [a-b]  Will find all the enteries in a field that are one
              character in length and =a through to =b.
              i.e  [5-7] would find numbers 5,6 and 7.

       [a-b]* Will find all the enteries in a field that being with the
              character a through to character b.
              i.e  [C-K]* would find all enteries whose first character
              is C,D,E,F,G,H,I,J or K and has any number of following
              characters.
------------------------------------------------------------------------
The filtered records are usually output to the screen , but you can also 
èoutput them to a printer or a disk file , by changing the filter output 
èon the options menu.
------------------------------------------------------------------------
The filtered records are as default displayed a single record per page , 
èbut this can be changed for another viewing mode by changing the filter 
èdisplay on the options menu.
------------------------------------------------------------------------

When you are viewing the filtered records , you have three options
buttons to choose from :-


 Quit - Will stop filtering and return you to the standard edit screen.

 Auto - Will automatically display the filtered records without you
        having to click the mouse on the NEXT option.
        Clicking the mouse button when this option is selected will
        stop Automatic filtered record display mode.

 Next - Displays the next filtered record.
        The next record can also be displayed by just clicking the
        left mouse button anywhere other than the three buttons.

