Archived discussions are read-only. Learn more about SAP Q&A

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

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...

Tags:
replied

Search the forum for the keyword 'LIKE'.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question