How do I get the VB4 Access Jet Engine to do case-sensitive queries? Eg.
SELECT * FROM someTable WHERE someField = 'i'
Here "someField" is assumed to be a text field, and I would like only 'i' records (and not 'I' records) to be returned. The default behaviour seems to be case-insensitive.