Greetings All,

It is easy enough to use IF in this manner:

If {CnGf_1Note_1.CnGf_1Note_1_Actual_Notes} = "Host Committee 2008 - Gala" Then

"Host"

Else

 " "

But what function could be used to see if the field contatins "Host" rather than equals? I need this to be more flexible than looking for "Host Committee 2008 - Gala".

The LEFT function works okay for this, but I think contains would be better.

Thanks!

Bryce

If "Host" in {CnGf_1Note_1.CnGf_1Note_1_Actual_Notes} Then "Host"

(Also, you don't need the "else" portion of the formula.  If the statement is false, nothing will show up anyway)

It worked. 

Thank you sir. You're a legend!

Happy to help.