> 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