Filtering data in multibox

[#1]

Hi,

I have a multibox with column name STATE with the values (US, UK, IN, PK, AUS).

I want to do some filter using wildmatch to get only US and UK.

Can any one explain me how to use wildmatch,

Is the below condition is right??

=WildMatch([STATE],"US","UK")

Thanks,

[#2]

Hi,

I am using for this a button with a select - trigger and the search string:

= '(' & 'US & '|' & 'UK' & ')'

HtH, Roland

[Miguel_Angel_Baeyens]

Hello,

If you are not going to use wildcards, Match will work better. So in your multibox add an expression

=If(Match([STATE], 'US', 'UK'), [STATE])

Hope this helps.