Re: [sqlite] ORDER BY - Case In-sensitive

[Dennis Cote]

Tony Fenleish wrote:

Is there a setting or a different of changing this to Case In-sensitive other than using UPPER:

Tony,

Yes, use the NOCASE collation as shown below.

   sqlite> SELECT * FROM(
      ...>  SELECT 'Apple' AS name
      ...>  UNION
      ...>  SELECT 'apple' AS name
      ...>  UNION
      ...>  SELECT 'banana' AS name
      ...>  UNION
      ...>  SELECT 'orange' AS name
      ...>  UNION
      ...>  SELECT 'Banana' AS name
      ...> )
      ...> ORDER BY name COLLATE NOCASE;
   Apple
   apple
   Banana
   banana
   orange
   sqlite>

HTH
Dennis Cote