Selection Set

[Robert Haussmann]

> 
> I'm not remembering a basic....
> 
> Using a selection set, can you force an exact match
> 
> For example, I want all companies that are named "Ace ".
> 
> If I do a scan on field 1 (company name) I get everyting that starts with the
> characters "ACE".
> 
> 
> 
> I don't want "Ace Hardware" or "Ace Lumber", I just one the companies that
> have a field number 1 (Company Name) equal to "ACE ".  Is there a way to
> get that using a selection set or do you need to use processing table?
> 

We've had to do this in the past, and found that the following works:

Group   Field  Heading                 Rel    Value
------------------------------------------------------------------
         1     name                    eq     Ace
         1     name                    le     Ace !

The above will bring back records where name='Ace', but not 'Acer', 'Ace Hardware', etc.

Bob Haussmann