Using a LIKE in input parameter with filter expression

[former_member821934]

I'm using a input parameter: NumeroAffaire with a filter expression :

<code>"NumAffaire"='$$NumeroAffaire$$'

When I enter specific number (example:000933782201109-1), it will work good. For example, I'm doing that:

Now what I want to do, it's to enter only few number (example:00093378220110) and it show me all possibilites data

So, I think I need to use a LIKE and i'm doing this but don't work:

<code>  "NumAffaire" like '$$NumeroAffaire$$%'

It's possible to explain me the correct syntax for using a LIKE in input parameter with a filter

Thank you