I have a report I have developed against and Oracle database and we are trying to sort this by name. I have these 2 names
A. N. INSURANCE and A+ INSURANCE
+ is ascii character 43 and . is ascii character 46.
When I run the query in sqlplus, A+ comes before A. but in the crystal report A. is coming before A+
How do I work around this so the query returns consistent results in both a sql editor and the crystal report?
I am using Crystal Reports 2016 support pack 9 Patch 4.