Upper case and Lower case functionality in HANA

[Former Member]

Hi friends,

Do we have any functionality in HANA to convert data from upper case to lower case and vice versa?

I need to convert Upper case string data type values to Lower case in a Calculated attribute.

I do not think we have any such functions for now with in Calculated attributes.

Please let me know if anyone of you have done it or anywork arounds for same.

Thanks & Regards

Harish Kumar Karepe

[former_member182302 · Accepted solution]

Hi There,

For Upper Case:

In the calculated column : try with the following syntax

UPPER(<Columnname>)

Ex: UPPER ("COLUMNA") or UPPER('KrIsHnA)

It is working fine for me.

Regards,

Krishna Tangudu

[Former Member · Accepted solution]

Hi Krishna,

You are right,It is working in the latest version.. Last time i tried it didnt work.

I appriciate your help!! Thanks

Regards,

Harish Kumar Karepe