Skip to Content
Jun 05, 2014 at 12:54 PM

relacement of NP relational operator in select queries


Dear experts,

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,