Calculation Function that checks for partial text
In my database I have the following calculation to indicate security deposit amounts required upon booking we have three companies that do not require a security deposit:
ValueCount ( FilterValues (proposal_CONTACT::CompName; "ABC" )); 0;
ValueCount ( FilterValues (proposal_CONTACT::CompName; "DEF Event Technology" )); 0;
ValueCount ( FilterValues (proposal_CONTACT::CompName; "GHI Media Services" )); 0;
The issue I am running into is the second and third line are fine but for company "ABC" we have about 80 different variations. ABC, ABC Presentation Services, ABC Orlando, ABC Las Vegas, ABC Media, etc.
Is there a calculation function I can use to indicate if the company name contains "ABC" to make the security deposit 0? I have tried PatternCount, ValueCount, Count but it seems that unless it matches "ABC" exactly, it won't make the security deposit 0.