How to use * in this case?

[#1]

I have a number field names like     Product A TRx Volume Trend in Market X

Product B TRx Volume Trend in Market  Y

Product C TRx Volume Trend in Market Z

and so on..........

when each one will be selected a chart will appear........... I want to know how can i use *  before and after the common part TRx Volume Trend    in LAYOUT- conditional.............so that i have write only one expression..........for eg:-   if(Name='* TRx Volume Trend In market',1,0) but here I m getting error.........Thanx in Advance

[jagan]

Hi,

Try using WildMatch() for this,

If(WildMatch(FieldName, '* TRx Volume Trend In market'), 1, 0)

Hope this helps you.

Regards,

Jagan.