UPPER and LOWER case in SQLScript


Mit dem Laden des Videos akzeptieren Sie die Datenschutzerklärung von Vimeo.
Mehr erfahren

Video laden

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> .

Pages 171-172 in the book