Which sorting does ms access use for strings?

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

Guest

I have a table with one text field.
3 records:
F-28
F111*
FAZ*

When I sort on this field I expect the following
F-28
F111*
FAZ*

Howerver I get
F111*
F-28
FAZ*

My database sorting is set to general.
When I go check the ascii table the - becomes before 1 and A
What is the sorting MS Access uses is there a table so I can check.

Kind regards
 

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

Query Returning Multiple Results 1
MS Access Avoiding redundancy 1
Sort syntax for multiplie IIF 2
find the latest date in access 2007 1
query sort on date 2
Character length 1
character length 2
Sorting Numeric Data in Text Field 1

Back
Top