NAV 2013 Sorting Problem with field type Code

cesabo

Hi Everyone,

I found difference between sorting of Nav 2009 and Nav 20013(maybe something is changed), let me show you quick example:

Nav 2009:
I have simple table with one field - type code, i insert 5 rows:
1: TEST A
2: TEST- A
3: TEST B
4: TEST- B
5: TEST

When i print the records with report, the report sort them like this:
1: TEST
2: TEST A
3: TEST B
4: TEST- A
5: TEST- B

Nav 2013:
I Create the same table, again one field, but when i print the records with report, it sort them like this:
1: TEST
2: TEST A
4: TEST- A
3: TEST B
5: TEST- B

Any idea ? The whole information in the database is not sorting correct, i checked the collations, compared the "Alter" information in the both databases ... what i am missing ?

Greetings.

cesabo

Thanks for the answer.
I don't find that natural sorting very useful, is there any way to use the old way of sorting ?