How to sort on a column with ignoring case
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 ?