Searching field for specific word

[Anonymous]

I would like to highlight the background colour of a dimension value when it includes the word 'primary' e.g. Williamston Primary School.  I have been trying to change the background colour on my dimension using the following expression -

=If([School Name]='*Primary', Yellow(),)

But it doesn't work.  What should I use instead of the *

Thanks

Greg

[sunny_talwar]

May be use WildMatch

=If(WildMatch([School Name], '*Primary'), Yellow())

[Anonymous]

Thanks but it didn't work.

[sunny_talwar · Accepted solution]

May be you need an * at the end too?

=If(WildMatch([School Name], '*Primary*'), Yellow())

[Anonymous]

Thanks.  That worked!

[sunny_talwar]

Superb