Column Sort doesn't match Order By Sort

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