BPM condition lookup 'contains' within field value

Try this:

FOR EACH whsebin WHERE whsebin.desc MATCHES ("*DO NOT USE*").

Ross


--- In vantage@yahoogroups.com, "jim_chance" <jim_chance@...> wrote:
>
> Is there a way to examine a field in a BPM condition that would examine a field and look for a matching literal contained within the field?
>
> I need to look for the words "DO NOT USE" in the whsebin.desc field.
>
> T-SQL code would be:
> select * from whsebin where whsebin.desc like '%DO NOT USE%'
> For anything before or after the literal DO NOT USE
>
> How can this be done in the BPM condition - perhaps something in the value to wildcard (contains within)?
>
> Thank you.
>
Is there a way to examine a field in a BPM condition that would examine a field and look for a matching literal contained within the field?

I need to look for the words "DO NOT USE" in the whsebin.desc field.

T-SQL code would be:
select * from whsebin where whsebin.desc like '%DO NOT USE%'
For anything before or after the literal DO NOT USE

How can this be done in the BPM condition - perhaps something in the value to wildcard (contains within)?

Thank you.