Announcement

Collapse
No announcement yet.

How to sort on a column with ignoring case

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to sort on a column with ignoring case

    The default sorting using orderBy clause is case sensitive, means, it first sorts the Words starting with CapitalCase and then sorts lower case (order by <Column_Name> ASC) . Is there a way to make it case insensitive like we have in other SQL database. For now , i have used something like : order by lower( <Column_Name> ) DESC . Is this a right way to do as I see some performance impact if number of records is large ?
    Last edited by msodhi@wdtablesystems.com; 09-07-2017, 09:57 AM.
Working...
X