Sorting Abnormality

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

Guest

I'm trying to clean up some data in a database I was given.

One of the fields (Text, 50) is a unit designator, some of which are
hyphenated. When I sort by this field, I get some results that I did not
expect.

Unit_Designator
21
2-1
22
2-2

I expected:
21
22
2-1
2-2

Any idea why these are not sorting appropriately?
 
Dale Fye said:
I'm trying to clean up some data in a database I was given.

One of the fields (Text, 50) is a unit designator, some of which are
hyphenated. When I sort by this field, I get some results that I did
not expect.

Unit_Designator
21
2-1
22
2-2

I expected:
21
22
2-1
2-2

Any idea why these are not sorting appropriately?
Click to expand...

Jet 4.0 treats the hyphen as a special character in text sorts. See
this KB article:

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