Sorting anomoly on a single line text field

I have the primary key column with a single line text field of venues. When I attempt to sort them in ascending order 1 record won’t sort correctly.
Cate’s Place, South Australia
– is sorting before
Adelaide Recording Studios, South Australia.

All the other records after this are sorting perfectly.
I’ve even tried removing the apostrophe, but that didn’t change anything.

Sounds like you have a leading space before the name.


Good catch ScottWorld, I did a copy / paste from the website. It looked like it was inline with the other text. Thanks for the reply / quick fix.

You’re welcome! Glad I could help!

1 Like

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.