Create following data set:

Solar - D

Solar - H

Solar - I

Solar - N

Solar FM - W I

Solar FM - W I

When you sort the above in query analyzer grid results, you'll get:

Solar - D
Solar FM - W I
Solar FM - W N
Solar - H
Solar - I
Solar - N

Similar, if you had table names w/ the above names and then chose to auto-complete, you'll get the same sorting result. For auto-complete, this behavior changes was introduced in ADStudio v10.0 to fix this issue: https://www.aquaclusters.com/app/home/project/public/aquadatastudio/issue/5533

Reference information:

http://docs.oracle.com/javase/1.5.0/docs/api/java/text/Collator.html

http://userguide.icu-project.org/collation/concepts

We use the Java Collator class to perform locale-sensitive string comparisons. When using the Java Collator class, punctuation (whitespace, dashes, etc) are ignored.