Hello,

I am using CR11.

I have six fields in my sql database from which I will only show three that are required. These are {SellPrice}, {SortCode} and {ProductCode}.

The {ProductCode} contains "A" codes like A11010001 to A11010020
and "C" codes like C1000021001 to C1000021035 (different string lengths).

The {SellPrice} has different pricing for "A" codes and also for "C" codes.

The {SortCode} contains only "A" codes for certain prices in the {SellPrice} field.

My question is: how do I write a formula that will first find an "A" code in the {SortCode} field. If "A" code is not found then give {SellPrice} for {ProductCode}. If "A" code is found in {SortCode} then match it with the "A" code in the {ProductCode} and give a different price in the {SellPrice} field.

Please help. Thanks.