模糊查找

 

DATA R_YEAR TYPE RANGE OF ZTAB_SD006-ZMONTH WITH HEADER LINE.

R_YEAR-SIGN  = 'I'.
R_YEAR-OPTION = 'CP'.
CONCATENATE '*' P_YEAR '*' INTO R_YEAR-LOW.
APPEND R_YEAR.
CLEAR R_YEAR.

select * form ztab_sd006 into # where %% in r_year.