topic SQL LIKE statement help in Application Development and Automation Discussions

SQL LIKE statement help

Former Member — Fri, 27 Jun 2008 17:15:11 GMT

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 — Fri, 27 Jun 2008 17:16:29 GMT


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

Greetings,

Blag.

Former Member — Fri, 27 Jun 2008 17:45:55 GMT

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 — Fri, 27 Jun 2008 18:55:41 GMT



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

ENDIF.

rainer_hbenthal — Fri, 27 Jun 2008 19:02:29 GMT

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 — Fri, 27 Jun 2008 19:06:20 GMT

Hi,

SELECT SOMETHING INTO VARIABLE FROM TABLE

WHERE PARAM1 LIKE '%-%'.

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