10-14-2008 11:27 AM
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
10-14-2008 11:31 AM
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.