topic Re: Select with like % in Application Development and Automation Discussions

Select with like %

jyothsna1234 — Sun, 05 Jun 2022 21:02:27 GMT

Hi,

I am going through some of SAP tutorials and found the following:

SELECT * FROM SPFLI WHERE CITYFROM LIKE '_R%'.

WRITE: /10 SPFLI-CARRID, 20 SPFLI-CONNID,

30 SPFLI-CITYFROM.

ENDSELECT.

following is my resulting list which doesnot include SINGAPORE.. Can someone explain why?

Thanks

Re: Select with like %

anujawani242683 — Mon, 06 Jun 2022 05:53:56 GMT

Hi,

I tried the below query it's working. if you write underscore before R then it will consider you are looking for the word with the second character as R and if you write %R% then it will look for the word with R character.

SELECT * FROM SPFLI WHERE CITYFROM LIKE '%R%'.
WRITE: /10 SPFLI-CARRID, 20 SPFLI-CONNID,
30 SPFLI-CITYFROM.
ENDSELECT.

I hope this helpful.

Regards,

Anuja Kawadiwale

Re: Select with like %

venkateswaran_k — Mon, 06 Jun 2022 06:03:41 GMT

As per your where clause

WHERE CITYFROM LIKE '_r%'

--Finds ALL values that have "R" in the second position of the string.

Re: Select with like %

RaymondGiuseppi — Tue, 07 Jun 2022 08:29:11 GMT

Review your course materials, % represents 0, 1 or multiple characters, _ represent a single character.

Can you guess your mistake?