Search code examples
sqlmonetdb

Is it possible to sort by lower case in MonetDB?

Is it possible to do an 'Order by lower(field_name)' in MonetDB?

Solution

  • Yes, that's exactly it. It's the lower() function.

    select lower('Hello')

    will return 'hello'. And I've confirmed that this works in the 'order by' clause as well.