SQL LIKE statement help

[Former Member]

Hi all,

I want to select all values from prps-usr00 where the field contains XXX-XXXX...where X is any letter or number. How in the world do I do that?

Thanks,

Mat

[Former Member]

SELECT SOMETHING
INTO VARIABLE
FROM TABLE
WHERE PARAM1 LIKE '%-%'.

Greetings,

Blag.

[Former Member]

Hi Mathew,

Select *
into itab1
from prps-usr00 
where <field> eq XXX-XXXX.

Itab1 is an internal table.

Hope this would help you

Regards

Narin Nandivada.

[Former Member]

SELECT * mara
INTO TABLE i_mara
WHERE matnr like '%XXX-XXXX%'.
IF sy-subrc eq 0.

ENDIF.

[rainer_hbenthal]

Open SQL does not offer regular expressions, so the only thing you can do is look for the hyphen:%-%

Can xxx-xxxx occur at any position or is it always at a certain position?

[Former Member]

Hi,

SELECT SOMETHING INTO VARIABLE FROM TABLE

WHERE PARAM1 LIKE '%-%'.

Or

If you know that there will be exactly 2 char in front of '-' and 2 char after. then use.

SELECT SOMETHING INTO VARIABLE FROM TABLE

WHERE PARAM1 LIKE '__-__'.

Regards

madhu

Edited by: madhu tatikonda on Jun 27, 2008 9:08 PM