Stuart McLachlan
stuart at lexacorp.com.pg
Tue Sep 26 15:55:01 CDT 2006
On 26 Sep 2006 at 15:30, pedro at plex.nl wrote:
> Hello Gustav and Stuart,
>
> thanks for your help.
> It is working, but i forgot to tell that most record where i need to filter
> on ER, have other tekst in the record. So i would need *ER*, but this isn't
> functioning in your query.
>
The solution I gave is for exactly that situation. There are implicit
leading and trailing wildcards.
ExactMatch("here,"ER") returns false
ExactMatch("hERe", "ER") returns true.
--
Stuart