Determining if a field contains a specific value

[ShannonM]

Hi,

I am having a problem with a calculation involving an IF function.

I want the IF statement to be based on whether or not a field contains a specific value. However, I am having trouble differentiating between the field containing just that value vs. that value along with other values.

The field in question is based on a value list of countries.

The beginning of my IF statement is:

If(CountryName="Canada";"CA").

For most records the CountryName field contains many different countries, not just "Canada" alone. I want the calculation to work on any record that has "Canada" but not only "Canada".

So right now it is not applying the calculation to any records that have:

Canada

USA

Australia

In the Country Name field. That is, the calculation is only being applied to records that have "Canada" only in the Country Name field.

Is there a way to fix this in the syntax of my calculation?

[MarkWilson]

If( PatternCount( CountryName ; "Canada" ) ; "CA" ; "" )

[Vaughan]

Duplicate post. Grrrrrr.