Exact Matches...

[Shane Gray]

> -----Original Message-----
> From: filepro-list-bounces+fplist=satsof.com.au at lists.celestial.com
> [mailto:filepro-list-bounces+fplist=satsof.com.au at lists.celestial.com] On
> Behalf Of Stanley - stanlyn-com
> Sent: Thursday, 26 April 2012 6:58 AM
> To: filepro-list at lists.celestial.com
> Subject: Exact Matches...
> 
> Hi,
> 
> 
> 
> How do you find records via the interface's "2-Scan for Records" that
match
> exactly. That is the right side must match the left side exactly.
> 
> 
> 
> Here is an example:
> 
> 
> 
> The table has 165,000 records where the item # is "Sales Tax" and there
are
> a few records where the value is "Sales Ta".  Every way I've tried, it
> returns all the "Sales Tax" records and there is hours and hours of wading
> to do.  I know how to get it via code, but this needs to be user friendly
on
> their interface.  I was hoping to see an "EX" option, like eq, lt, gt, ne,
> and etc to handle this, but its not here.
> 
> 
> 
> Is there anything like "Set Exact on" that could be used for this?  I hope
> so.
> 
> 
> 
> Thanks, Stanley
> 

Try using the wildcard (=) character in the value.

e.g.  eq "Sales Ta ="

Will match anything starting with "Sales Ta ".

Regards
Shane.