[AccessD] capitals in query

pedro at plex.nl pedro at plex.nl
Tue Sep 26 15:30:18 CDT 2006


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
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 



More information about the AccessD mailing list