Selection Set

[Mike Schwartz]

> > 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?
> >
> > Regards,
> > Scott
> 
>     Are you thinking of using  "CO" for contains in the "Rel" field of the
> selection set?
> 
>     If you do that, "ACE" will select "Appleton Ace Cleaners".
> 
>     Or are you thinking of the "=" (equal sign) that is a wild card character
> (matches any character).  If you use "=" you would not fine "Appleton Ace
> Cleaners".
> 
> Mike Schwartz
> 
> 
> 
> Mike,
> 
> I just want to find the company with the name field that is "ACE ".
> 
> The content of the field starts with the characters "ACE" and then is
> followed by 32 blanks.
> 
> Can a scan produce that (and only that ) match or does that have to happen
> in processing?
> 
> Regards,
> Scott

     So you only want to find "Ace" and not "Acer" or "Ace Company"?

     Then, as I recall, you have to resort to processing.  The following might eliminate "Acer", but will probably not eliminate "Ace Company".
    
 Group   Field  Heading                 Rel    Value 
          *  2  * Company Name            ge *   ace 
             *  2  * Company Name            lt  *   ace!!

     (I don't know why the two exclamation points won't eliminate any greater characters, like the "C" in Company. "C" is greater than an "!" in ascii...)

Mike Schwartz