Skip to Content

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

Query with Like

Hello,

I want to create a query to find all articles that start with a certain string.

I have tried this:

SELECT T0.ItemCode FROM OITM T0 WHERE T0.ItemCode LIKE '_%' + LTRIM(RTRIM('[%0]')) + '%'

but this doesn't do the job.

rgds,

John

Former Member
Former Member replied

sorry if you want articles that start with a defined string is

SELECT T0.ItemCode FROM OITM T0 WHERE T0.Itemcode LIKE '[%0]%'

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