Using select with uppercase.

Former Member — Sat, 24 May 2008 04:01:35 GMT

Hi friends ,

I have been asked to retrieve vendor list just by entering

short word.

I worked and developed this report but i want to improve it on processing speed.

At present i retrieve complete list of vendors in an internal table and the do drilling down in subsequent internal tables by

using CS <shortword>.

But i feel initially when i select complete list of vendors in internal table is making my report time consuming.

I want to use LIKE with select.

In order to overcome case-sensitvity issue i want that i should pick itself in select using LIKE irrespective of any case ?.

Is some way there ?.

I wish to convert like

select lifnr TOUPPER(name1) from lfa1.

Thereby converting shorttext to UPPER,comparison will become easy.

Re: Using select with uppercase.

Former Member — Sat, 24 May 2008 04:07:08 GMT

something like this

select lifnr into name1 from lfa1..

translate name1 to uppercase.

append name1 to ltab.

(code}

Former Member — Sat, 24 May 2008 04:09:52 GMT

No, translate will work only after taking all content.I tried this already.