Skip to Content
0
Former Member
Sep 06, 2007 at 10:45 PM

Ignore case in Select Statement with Select-Options..!!!

1776 Views

Hi Experts,

Currently iam using the following SELECT query,

SELECT bktxt FROM BKPF into g_bktxt

WHERE BKTXT IN s_bktxt.

Here, the issue is - in SE11 for BKPF-BKTXT they maintain different combinations of BKTXT values like : WA, wa, Wa, wA.

Now, when an user gives 'wa' in select options (s_bktxt) then i need to pull all (WA, wa, Wa, wA) combinations from database - irrespective of Case ( Case Insensitve or Ignore Case ) at the input select-option - s_bktxt.

How to achieve this...?

Any suggesstions / Ideas will be of great help.