Which sorting does ms access use for strings?

[CSI member]

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

 

[Allen Browne]

When Microsoft released Access 2000, they stuffed it up so the sorting is
inconsistent if the field contains a dash.

Details:
http://support.microsoft.com/default.aspx?scid=kb;en-us;236952