Sort Records In Case Sensitive Order. Choose a case-insensitive collation select from your_table order by your_column COLLATE utf8_general_ci That way indexes still work and the query is fast. For example the values smith and Smith will be treated as exactly the same and you cannot control which one will appear first.
Values in a multi-value field will be sorted alphabetically regardless of the order in which they display. How to do case- or accent-insensitive sorting. 8 Zeilen Access sorts records in ascending or descending order without regard to case.
With sample_data as select A txt from dual union all select B txt from dual union all select Y txt from dual union all.
A 65 _ 95. The following user-defined function can be used to sort data in case-sensitive order. Will be sorted separately to. C Office Tab Enable Tabbed Editing and Browsing in Office and Make Your Work Much Easier.