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.