SyntaxFix

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

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

Examples related to sql

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Generic XSLT Search and Replace template • Access And/Or exclusions • Pyspark: Filter dataframe based on multiple conditions • Subtracting 1 day from a timestamp date • PYODBC--Data source name not found and no default driver specified • select rows in sql with latest date for each ID repeated multiple times • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database

Examples related to sqlite

• getting " (1) no such column: _id10 " error • Laravel: PDOException: could not find driver • auto create database in Entity Framework Core • How to open .SQLite files • Accessing an SQLite Database in Swift • When does SQLiteOpenHelper onCreate() / onUpgrade() run? • Attempt to write a readonly database - Django w/ SELinux error • Android sqlite how to check if a record exists • How can I add the sqlite3 module to Python? • "Insert if not exists" statement in SQLite

Examples related to sorting

• Sort Array of object by object field in Angular 6 • Sorting a list with stream.sorted() in Java • How to sort dates from Oldest to Newest in Excel? • how to sort pandas dataframe from one column • Reverse a comparator in Java 8 • Find the unique values in a column and then sort them • pandas groupby sort within groups • pandas groupby sort descending order • Efficiently sorting a numpy array in descending order? • Swift: Sort array of objects alphabetically

Examples related to sql-order-by

• Laravel Eloquent: Ordering results of all() • SQL for ordering by number - 1,2,3,4 etc instead of 1,10,11,12 • SQL ORDER BY multiple columns • How to use Oracle ORDER BY and ROWNUM correctly? • MySQL order by before group by • Ordering by specific field value first • MySQL ORDER BY multiple column ASC and DESC • How can I get just the first row in a result set AFTER ordering? • SQL order string as number • Order by multiple columns with Doctrine