[AccessD] capitals in query

Gustav Brock Gustav at cactus.dk
Tue Sep 26 07:42:49 CDT 2006


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




More information about the AccessD mailing list