Exact Matches...

[Stanley - stanlyn-com]

Hi Shane,

> eq "diesel     =" (inserting more spaces before wildcard so wildcard at
end of field)
Well, I'll try this...  

So, if I eq "diesel f=       ", (notice the spaces after the = sign), 

I'd get
Diesel fuel
Diesel farm

And not

Diesel
Die...

Because both sides must match up to the "=" sign???

If so, then that clears up a lot...

Thanks, Stanley



    


-----Original Message-----
From: Shane Gray [mailto:shane at satsof.com.au] 
Sent: Friday, April 27, 2012 9:14 AM
To: Stanley - stanlyn-com
Cc: filepro-list at lists.celestial.com
Subject: RE: Exact Matches...



> -----Original Message-----
> From: Stanley - stanlyn-com [mailto:stanley at stanlyn.com]
> Sent: Friday, 27 April 2012 5:44 PM
> To: 'Shane Gray'
> Cc: filepro-list at lists.celestial.com
> Subject: RE: Exact Matches...
>
>
> 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"
>
> Thanks, Stanley
>

eq "diesel     =" (inserting more spaces before wildcard so wildcard at end
of field)