"Case sensive" indexes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I've got problems in creating indexes dealing upper case and lower case
strings as different strings.

So I find an ordered table like this

abcd
Adgr
aste
Feor
fast
Zytr
zero

when I need

abcd
aste
fast
zero
Adgr
Feor
Zytr

Something like the Database/Binary choice in the "Option Compare" VBA
directive.

I haven't found anything similar in creating indexes.

Can you show how to do this (if possible, of course).

Thanks in advance.
 
It's not possible. By default, Access is not case sensitive, and there's no
option to change that behaviour.

To do what you're trying to do, you'd have to write a function to convert
the text into its ASCII representation and store that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

distinguish upper/lower case in unique index? 4
Lower-Case Characters 2
Text insert in indexed fields with "no duplicate" property 1
How to convert lower case index entry tag to upper case? 3
Upper and Lower Case formats 2
How do I create an Index with both Capital & Lower cse words? 2
Can I make index entries in Word not case-sensitive? 2
To index or not to index 2

Back
Top