topic Re: Operator for Not considering Case in Application Development and Automation Discussions

Operator for Not considering Case

Former Member — Fri, 23 May 2008 05:11:54 GMT

Hi all,

Can anybody tell me

Operator by which internally it not consider the case(Upper case or lower case)and accordingly fetch the data.

For ex if we enter Either

Ram or ram of Ram.

Consider all the same.

Best Regards,

Aastha

Re: Operator for Not considering Case

rainer_hbenthal — Fri, 23 May 2008 05:32:50 GMT



orig_value = 'Ram'.
tmp_value = orig_value.
translate tmp_value to upper case.

case tmp_value.
  when 'RAM'.
    do_something.

  when 'ROM'.
    do_somehting_else.

  when others.
    do_error_handling.
endcase.

Re: Operator for Not considering Case

Former Member — Fri, 23 May 2008 05:55:10 GMT

Hello Rainer,

Can u tell me the particular case insensitive function.

Best Regards,

Aastha

Re: Operator for Not considering Case

rainer_hbenthal — Fri, 23 May 2008 05:58:34 GMT

Hi, i really dont understand for what you are asking now...

Re: Operator for Not considering Case

Former Member — Fri, 23 May 2008 06:43:32 GMT

Hello again Rainer,

I m asking that whether we enter in selection screen(for ex)

Ram or

RAM or

rAm or

all such possible combinations.

I m asking any logic, so that my report will consider all these combination same and fetch the records.

Best Regards,

Aastha