LPL Syntax Equivalent to SQL LIKE or Contains Filter in Reports

tyeung

I am working on a report and need to filter positions where the description contains a specific keyword. In SQL, I would typically use LIKE '%MSW%', but I'm trying to achieve the same in LPL.  Is there an LPL syntax equivalent to SQL LIKE or a way to apply a "contains" filter on a report? Specifically, I want to pull all positions where "MSW" appears in the description.

Any guidance or examples would be greatly appreciated!

cleverly

Try the LPL contains condition operator; see page 43 in the current LPL guide.