Query with Like

This question is answered

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

Correct Answer

April 21, 2006 at 11:08 AM

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

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

0 Likes 0 View this answer in context