Exact Matches...

[Barry Wiseman]

On 4/25/2012 4:58 PM, Stanley - stanlyn-com wrote:
> 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
>
>
I agree with you, there should have been an "EX" relation -- and as I was a member of the design team I accept a share of the blame for its absence, I never realized the need until several years too late.

Fortunately, the workaround is often easy, as in your case.  Search for "eq Sales Ta" AND "ne Sales Tax."