wb38
09-30-02, 15:17
| I've not been able to find any documentation about how to alphabetically sort a query regardless of case. For instance, I have a glossary where all words should be ordered in dictionary-style, case insensitive. But "...ORDER BY wordcolumn ASC" always returns the capitalized words first, then all others. Is there a way to override PostgreSQL's default alpha sorting, or specify case insensitivity in the SQL query? |