distinguish upper and lower case

[captnk]

Is it possible to get Access to distinguish between upper and lower case (First alpha),in a query /sort.
The relevance being being that the Upper case alpha is of more importance (ranked higher )than the lower case alpha.
Thanks

 

[raskew]

You could use the ASC() function to append "1" to your string for lower case or "0" for upper case. When sorted, the identical strings (except for the case of the first character) will appear in the desired order. Here's an example using tblProjects with field [Loc]. Copy this to a new query then change the table and field name to agree with your criteria.

SELECT tblProjects.Loc
FROM tblProjects
ORDER BY [Loc] & IIf(Asc(Left([Loc],1))>=97,1,0);