How can I filter a Gridview with:

AND(
{Doc Type} = "C",
{Line Type} = "C",
{OELine Description} containing the word "PRICE"
)

The first 2 lines are fine but is there a way to filter it to show me all the comment lines that contain (but is not limited to) the word "price"??

I'm using the table: *OE Ord Detail w Head, IC

Hello Susan:

Use FIND("PRICE", UPPER({OELine Description}), 1) > 0

This means find the first place where "PRICE" occurs in the Description and return the position in the Description.

For instance:
-If the Description is "PRICE DISCOUNT", FIND() = 1
-If the Description is "NEW PRICE DISCOUNT", FIND() = 5
-If the Description is "NEW DISCOUNT", FIND() = 0

Thanks Bruce!!