PatternCount Question

[amypaulsmom]

I am using the Patterncount feature to find the work "signed" in a description field.

Here is my calculation: PatternCount(FoundDescription, "signed"). This works fine, except that it is only finally exactly the word "signed" - not SIGNED or Signed.

Can I adjust for this easily. I need to find the word Signed in any format within my FoundDescription field.

thanks -

[amypaulsmom]

Solved my own problem - by looking at the calculation field that I had attached to this field definition.

thaks

[Vaughan]

Yes PatternCount is case sensitive. One way around it is to make the field all lowercase for the purpose of the comparison:

PatternCount(Lower(fieldname), "signed")

It could have equally as effectively been made uppercase.