Sorting anomoly on a single line text field

[Pablo_Rios]

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.

[ScottWorld]

Sounds like you have a leading space before the name.

[Pablo_Rios]

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.

[ScottWorld]

You’re welcome! Glad I could help!