Forum: Other

Post: How to sort on a column with ignoring case

How to sort on a column with ignoring case
msodhi@wdtablesystems.com
Sep 5, 2017
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 ?