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
Jose Xabier Sanz replied
sorry if you want articles that start with a defined string is
SELECT T0.ItemCode FROM OITM T0 WHERE T0.Itemcode LIKE '[%0]%'