How to use SQL Order By statement to sort results case insensitive?

by

You can also do ORDER BY TITLE COLLATE NOCASE.

Edit: If you need to specify ASC or DESC, add this after NOCASE like

ORDER BY TITLE COLLATE NOCASE ASC

or

ORDER BY TITLE COLLATE NOCASE DESC

More Related Contents:

  1. SQL Query – Using Order By in UNION
  2. SQL how to make null values come last when sorting ascending
  3. Sorting null values after all others, except special
  4. SQLite and custom order by
  5. Alphanumeric sorting with PostgreSQL
  6. SQLite Order By Date1530019888000
  7. Selecting more than one value
  8. Is it possible to insert multiple rows at a time in an SQLite database?
  9. Natural Sort in MySQL
  10. SQL multiple column ordering
  11. How to order by with union in SQL?
  12. Declare variable in SQLite and use it
  13. Can I do a max(count(*)) in SQL?
  14. How to update and order by using ms sql
  15. SQL Server UNION – What is the default ORDER BY Behaviour
  16. Sort NULL values to the end of a table
  17. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  18. Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine
  19. Is there AUTO INCREMENT in SQLite?
  20. SQL: ORDER BY using a substring within a specific column… possible?
  21. Android multiple databases open
  22. How Can I Sort A ‘Version Number’ Column Generically Using a SQL Server Query
  23. Custom Order in Oracle SQL
  24. SQlite: select into?
  25. how does SELECT TOP works when no order by is specified?
  26. SQL ORDER chars numerically
  27. IF() statement alternative in SQLite
  28. Dynamic order direction
  29. SQLite query, ‘LIKE’
  30. ORDER BY alphabet first then follow by number

Leave a Comment