Sorting words with apostrophes

C

Charles McClellan

Access seems to be sorting apostrophes in words after all
other characters as follows

Dalton
D'Andrea

If I do the same sort in a module it sorts the apostrophe
before all other characters.

Is there any way of controlling how the strings are
compared?

Thanks
Charles
 
M

Michel Walsh

Hi,


It is not limited to Access:



"""""""""""""""""""""""""""""""""""""""""""""""""""
Dr. GUI replies:
Actually, the Win16 and Win32 sorting algorithms are almost identical. In
general, the order is this:

1.. Non-alpha-numeric (punctuation) characters in ASCII or ANSI order
2.. Numeric characters in numeric order
3.. Alphabetic characters in case-insensitive alphabetic order
For Win32 it is the same, with two exceptions: the hyphen or minus (-)
symbol and the single-quote or apostrophe ( ' ). These two characters are
ignored when sorting strings because they are allowed to be embedded in
English-language words. For example, "its" and "it's" and "co-op" and
"coop." The presence of these characters embedded in words causes certain
searches to break incorrectly, so they are changed to be treated just like
other diacritical marks embedded in text strings; that is, they're ignored."

"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""


Hoping it may help,
Vanderghast, Access MVP
 
Top