i would like to select the entries from a table which do not start with 'y' or 'z' as the relation operators are not allowed in select queries please help me on how should i achieve the my desired result.
my sample code is as follows(which of course has an error).
select tabname from dd02l into table itab
where clidep = ' '
and tabname np y*
or taname np z*.
i know the above code is incorrect but hope u understand my requirement.
thanks and regards,