String functions in inside bmql query

Content

I would like to use some string functions inside the bmql specifically lower and upper functions

For example:

In SQL we can do this:

SELECT  LOWER(department_name) FROM departments ORDER BY LOWER(department_name);

How can the same be achieved in bmql.

I have tried some combinations but I always end up with different errors.

I basically want to implement a search function with bmql against data in columns.

Any help would be highly appreciated.

 

Version

Version: 21C Patch 2

Code Snippet

SELECT  LOWER(department_name) FROM departments ORDER BY LOWER(department_name);