5 Replies Latest reply: Feb 10, 2009 6:59 PM by Marcin Pciak RSS

Using wildcard character * in where condition of select statement...

murali krishna
Currently Being Moderated

hi friends,

can any one help me how to write a select statement using wildcard character '*' in the where condition?

 

for example:

SELECT * FROM konv INTO CORRESPONDING FIELDS OF ls_konv

WHERE ( kschl = 'ZED1' OR

              kschl = 'ZDP1' OR

              kschl = 'ZDQ1' OR

              kschl = 'ZDPM' OR

              kschl = 'ZDQM' )

 

i want to write the same above code as

 

SELECT * FROM konv INTO CORRESPONDING FIELDS OF ls_konv

WHERE ( kschl = 'ZED1' OR

                 kschl = 'ZD*' ).

 

i want to fetch all the records which are starting with ZD (say ZD*) for the field KSCHL.

so how can i write the same in the select statement???

 

thanks in advance...

Actions