Query with Like

[Former Member]

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 · Accepted solution]

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

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

[Former Member]

Thanks

[Former Member]

Try

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