Skip to Content
0
Former Member
Jun 26, 2013 at 09:21 AM

Like operator in a select

16581 Views

Hi,

I need to compare with a like operator in a select.

For example, I have the following:

select matnr into ematnr from mast client specified

WHERE mandt = sy-mandt

AND werks EQ '3000'

AND stlan EQ '1'

AND stlal NE '01'

AND matnr like 'FA%'.

Can anybody tell how I can get this, the last AND.

In a string it would be something like this but, how it is in a select:

matnr+0(2) = 'FA'.

Thanks in advance.

Regards.