Select in upper and lower case - Is it possible ?
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 ?
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.
Edited by: Rob Burbank on Jul 10, 2009 12:44 PM