Re: MS Access case

From: Mike Williams (mikew12345@lvcm.com)
Date: 12/28/02


> My criteria looks like this: 'Like "*c"
> The results give: 'ac' 'aC' etc

The MS Access "like" operator is affected by the Option Compare setting.  If
you're using
"Option Compare Text" at the top of the form or module, it will force "like"
to be
case-insensitive.  Try using "Option Compare Database", I think that will
make it
case-sensitive.  If that doesn't work, email me off-line and I'll help you
find another way.

Mike
mikew12345@[nospam]lvcm.com

--
   +---------------------------------------------------------------+
   | FAQ: http://qsilver.queensu.ca/~fletchra/Circle/list-faq.html |
   | Archives: http://post.queensu.ca/listserv/wwwarch/circle.html |
   | Newbie List:  http://groups.yahoo.com/group/circle-newbies/   |
   +---------------------------------------------------------------+



This archive was generated by hypermail 2b30 : 06/25/03 PDT