All,

I am trying to search for a phrase ("Observed TRD3 Ufls" within a long string, and I am having trouble. Sometimes the sub string could be at the beginning, sometimes in the middle, and sometimes at the end. I am trying to something like

```
    MAX(CASE WHEN REGEXP_LIKE(B.shipment,'Observed TRD3 Ufls','i') THEN 1 ELSE 0 END) OVER (PARTITION BY d.Status) AS Tag

```

Sometimes observed can be observe so I need to be able to get both, and lastly it needs to be case insensitive.

Every result I review is always 0 instead of 1. Any help would be appreciated!