topic Re: Convert database field in uppercase in ABAP SQL in Application Development and Automation Discussions

Convert database field in uppercase in ABAP SQL

former_member421481 — Tue, 14 Oct 2008 10:27:52 GMT

Hello all,

I need to convert a database field into Uppercase in my ABAP SQL. How to do it?

See SQL:

Select a~opbel

from dfkkopkx AS a

where UPPER(a~stext) EQ variable

My variable is in Uppercase. That is why I need to convert the field stext in order for the comparison to work.

The Upper keyword does not exist in ABAP SQL. Please suggest.

Thanks,

Nas

Re: Convert database field in uppercase in ABAP SQL

Former Member — Tue, 14 Oct 2008 10:31:33 GMT

Hi,

If possible try converting the variable to the case corresponding to Table. Since i think its not possible to write such query in SAP.

Or you have to write a conversion exit for that field at database level. So any values going in for that field will be upper case only and you need not change to upper case during where condition specification.

Thanks & Regards,

Navneeth K.