Exact Matches...

[Kenneth Brody]

On 4/27/2012 3:44 AM, Stanley - stanlyn-com wrote:
> Hi Shane,
>
>> Try using the wildcard (=) character in the value.
>> e.g.  eq "Sales Ta ="
>> Will match anything starting with "Sales Ta ".
>
> Well, I just found a condition where the = wildcard isn't returning what I
> was expected, well actually I do expect what this is returning.  What I was
> trying to do was not using a wildcard.  Instead I was trying to do a left to
> right side comparison, which has nothing to do with a wildcard query.
>
> So here is the new issue.  I'm trying to find only the recs that exactly
> equals "Diesel" and not the records that is "Diesel Fuel".  The = wildcard
> gets both which is what I would expect, so is Walters solution of doing a
> double test of "eq "Diesel" and ne "Diesel Fuel"
[...]

Place the "=" wildcard in the very last character of the comparison value, 
not just after a single space.

-- 
Kenneth Brody