UPPER and LOWER case in SQLScript

To convert character strings into lowercase or uppercase letters, SAP has given SAP HANA several functions:

• UPPER(<character string>)
• UCASE(<character string>)
• ABAP_UPPER(<character string>)
• LOWER(<character string>)
• LCASE(<character string>)
• ABAP_LOWER(<character string>)
• INITCAP(<character string>) – From HANA 2.0 SPS02

For both ABAP_*-Functions is the return type NVARCHAR . For all others, the return type of the functions corresponds to the data type of the parameter <character string> .