Sorting Problem

When sorting text columns the native database will sort letters then numbers. The SQL version reverses this sort or places numbers before letters.

When using the SQL version I’ve been able to get the native behavior by using Navision’s temporary tables. The are created on the client and behave the same in either database.

My current problem is I have a native database and need to sort a text column like SQL does. Any thought?

Sorting in Native database if I’m not in mistake is coming from FIN.stx from a section called “sorttable”. I don’t think it’s possible to change that.

Yes, that is correct.

Used ADO to hold records in memory then sorted and processed. Solution came from one of our customers.