Given a set of records with a string field “name” that contains, for example:
Bob Sam [Zach] Jane [Mike]
Using ORDER BY name will return:
[Mike] [Zach] Bob Jane Sam
I would have expected this (items with square brackets at the end):
Bob Jane Sam [Mike] [Zach]
I wonder if this is the effect of case-insensitivity on the ORDER BY, but is it in fact case-insensitive? If so, how/where is that set? If not, what would cause this sort order (where the items with square brackets are first)?