Hi Guys,
In the native embedded database, the sort order for character values are symbols then the ascii characters.
In the MS SQL Server 2012 the sort order ignores the symbols. for example -

Native Database --C, AAS, BBA, CDA, DDF

SQL Database AAS, BBA, --C, CDA, DDF

Is there a setting that I have missed when converting to MS SQL.
Thanks for any help
Vicki