Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Convert database field in uppercase in ABAP SQL

former_member421481
Participant
0 Kudos

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

1 REPLY 1

Former Member
0 Kudos

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.