I know this problem something to do with sort and collation and string comparison vs numeric only strings, but I can't fathom out the details of it.
A tag that highlights questions on development, testing, deployment, management, etc using InterSystems Data Platform that are considered to be the most insightful, interesting, puzzling, or important. If a key question includes a best practice, it will also be tagged as such. More details.