Crystal Report formula (finding with key words) 1

[john432]

Hello,

I'm trying to create a report that will display a statement on certain customer reports.

My formula right now looks something like if {xxxx.Customer_name} = "Rockwell" then "statement"

How do I create the report to add the statement to any customer containing Rockwell?

With my current formula it will only display the statement when the customer name is exact, if it contains more than rockwell in the name the statement will not display

any help will be greatly appreciated.

 

[pmax9999]

If      {xxxx.Customer_name} LIKE '*Rockwell*'
Then    '"Statement"'

Cheers
Pete

 

[john432]

Thank you pmax9999, I was missing the asterisk.