Forum

Hello!
I have the following problem: I need to filter items in my catalog by a part of Description. I use LIKE clause but it maches entire the string like equal sign does! Here is my query text:

SEL ECT Items.Ref
FR OM Catalog.Items AS Items
WHERE Items.Description LIKE &DescriptionPart

Hello.
Try it like that

SetParameter("DescriptionPart","%"+DescriptionPart+"%")

Perfect! Thanks!