Prevent selection screen input fields conversion to upper case?

Siva  picture Siva · Jan 6, 2012 · Viewed 10.7k times · Source

I have the table with field title_medi which contains two rows like Mr. and Ms.

Also I have input field called title with search help of title_medi. When I'm selecting Mr. in the search help it gets displayed in the textfield.

If I compare that text field value with the database field. I'm getting an error.

But when I debug and see the value is somewhat getting converted to all uppercase like MR. not as exactly in the table.

Could you please help me out with this?

Answer

sepo picture sepo · Jan 6, 2012

In order to solve this you have 2 options:

  1. Go to the domain of the table field and check Lower case check this
  2. Use TRANSLATE ABCD TO LOWER CASE before making the comparison check this