Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Select in upper and lower case - Is it possible ?

Helle expert,

I have to make a select from BUT000 table. My selection's fields are NAME_LAST and NAME_FIRST.

My question is:

there's a command or an option that allow to select the row if the value is in upper case and also in lower case ?

I mean that I want to select if NAME_LAST is Roberto, or ROBERTO, or roberto.

any idea ?

tks.

Former Member
Former Member replied

Easy:

Instead of using NAME_LAST and NAME_FIRST in the SELECT, use the upper case translations that are used in the search helps: MC_NAME1 and MC_NAME2.

Always look for an upper case translation for fields like this before trying some sort of conversion in the SELECT.

Rob

Edited by: Rob Burbank on Jul 10, 2009 12:44 PM

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question