can you distinguish UPPERCASE/lowercase data?

[muneco]

I am relatiely new to Access 2000, and have a rather general question about text fields.

In my database, I have a "customer" table with a field "cust_name". If I query the customer table for distinct cust_name's I get all uppercase results. But if I visually scan the data in the table, or select all records in the table, I can see that there is also lowercase data in the table.

Does the "DISTINCT" qualifier that I used in my query not distinguish between upper/lower case and return only uppercase?

What if I WANT to select only lowercase cust_name = "abc" from table customer, is this possible? Are there other gotcha's that you can warn me about?

If you are familiar with this issue, please let me know. Thanks much in advance.

 

[lameid]

Access can be set to use two different types of comparisons, Binary or text. What your describing is a binary comparison whereas the default is text.
More specifically help talks about
Option Compare Text
and
Option Compare Binary

I have never had a reason to use binary, so I'm not sure how to make this change. I've seen it in VBA as a parameter to some functions and definition for a module but not the Global setting.

I hope this puts you on the right track.