Text Data Type Sorting Order

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sean - 11 Nov 2005 04:33 GMT

Hi All,

Thanks in advance!

I have a set of customer code in Office 97 which sorted as below:

CustomerCode
===========
SG-A
SG-B
SG-C
SGA-A
SGB-A
SGC-A

But in Office XP, the sorting order is different, it looks like:

CustomerCode
===========
SG-A
SGA-A
SG-B
SGB-A
SG-C
SGC-A

Does anyone have any idea on how to solve this issue?

Thank you very much.

Regards,
Sean

Reply to this Message

Allen Browne - 11 Nov 2005 04:59 GMT

Yes, Microsoft broke the sorting order when they released JET 4 (Access 2000
and later.)

They acknowledge the problem here:
Sort Order Has Changed with Microsoft Jet version 4.0
at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;236952

I don't think you can expect them to change their minds, because their
larger database product does the same thing.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi All,
>
[quoted text clipped - 28 lines]
> Regards,
> Sean

Reply to this Message