Skip to Content
0
Former Member
Aug 09, 2005 at 08:10 AM

how to use RANGES with SELECT

8750 Views

i am using ranges as follows, but it is not giving me desired result, pls correct me if i am doing something wrong.

values are changed, i want to know is this right way to use ranges with select.

IF var1 NE 'y'.

r_risklevel-low = abc.

r_risklevel-sign = 'I'.

r_risklevel-option = 'EQ'.

APPEND r_risklevel.

ENDIF.

IF var2 NE 'y'.

r_status-low = xyz.

r_status-sign = 'I'.

r_status-option = 'EQ'.

APPEND r_status.

ENDIF.

SELECT * FROM dbtable

INTO TABLE itab

WHERE priority IN r_risklevel AND

status IN r_status.

regards.