[AccessD] capitals in query

Hi Pedro 

Then you may use:

  Where 
    InStr(1, [YourField], "ER", 0) > 0

/gustav

>>> pedro at plex.nl 26-09-2006 15:30:18 >>>
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.

Any idea's 

Pedro



In antwoord op:

> From: "Gustav Brock" <Gustav at cactus.dk>
> To: <accessd at databaseadvisors.com>
> Date: Tue, 26 Sep 2006 14:42:49 +0200
> Subject: Re: [AccessD] capitals in query
> 
> 
> Hi Pedro
> 
> You can use 
> 
>   Where 
>     StrComp([YourField], "ER", 0) = 0
> 
> /gustav
> 
> 
> >>> pedro at plex.nl 26-09-2006 13:59:48 >>>
> Hello Group,
> 
> how can i search only for capitals in a query?
> i need ER not er.
> 
> Thanks
> Pedro