where condition of select statement doesn't deliver the expected result

[Former Member]

Hi all,

i do not know why my where-condition doesn't work.

Could anyone help me?

CONCATENATE
                '%'
                <fs_selopt>-LOW
                '%'
              into search_str.
              str_tbl = '/BI0/TEMPLOYEE'.
              SELECT * from (str_tbl) into wa_employee where TXTMD LIKE search_str .

[Former Member]

Is there anything in the field <fs_selopt>-LOW.

do you need to read your select-option with INDEX 1 to get the value.

[Former Member]

yes there is a value in the in the <fs_selopt>-LOW

[former_member181962]

Hi Anton,

Check for case sensitivity of the field in the where clause.

If it is stored as UPPER CASE in database, then you have to translate the <seloption>-low to Upper-case.

translate <seloption>-low to upper-case.

Regards,

Ravi

[Former Member]

Hello,

U could try like this

DATA: RA_TXTMD TYPE RANGE OF TXTMD WITH HEADER LINE.

DATA: LV_TXTMD(10).

RA_TXTMD-SIGN = 'I'.

RA_TXTMD-OPTION = 'CP'.

CONCATENATE <fs_selopt>-LOW '*' INTO LV_TXTMD.

RA_TXTMD-LOW = LV_TXTMD.

APPEND RA_TXTMD.

<b>IF NOT RA_TXTMD[] IS INITIAL.

SELECT * from (str_tbl) into wa_employee where <b>TXTMD IN RA_TXTMD</b>

ENDIF.</b>

Vasanth

[Former Member]

Hi,

CONCATENATE

'*'

<fs_selopt>-LOW

'*'

into search_str.

Create a range:

ranges: r_sel.

r_sel-sign = 'I'.

r_sel_option = 'CP'.

r_sel-low = search_str.

append r_sel.

Then,

str_tbl = '/BI0/TEMPLOYEE'.

SELECT * from (str_tbl) into wa_employee where TXTMD in r_sel.

Regards

Subramanian

[former_member194669]

Hi,

Try like this

CONCATENATE

'_____%'

<fs_selopt>-LOW

'%'

into search_str.

Thanks

aRs