When I used this code...
((select Table1) order by Text).Text
I noticed that the sort orders aren't the same.
This can be fixed using upper(), but I'm curious if that behavior is intentional
while the order in the table is not case sensitive, you have the possibillity to have case sensitive order with that function if you wish/need to have it.
It would be nice if the 'order by' worked in View. It is accepted as lefitimate, but has no effect on the outcome. I would suggest that it should take priority over user selections. including grouping.