[AccessD] capitals in query

If there is other text, try using INSTR().

Mike & Doris Manning
mikedorism at verizon.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of pedro at plex.nl
Sent: Tuesday, September 26, 2006 11:30 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] capitals in query

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