Range Formula Trancates Last Charter

[BlurredVision]

Hello all.. I have the following formula:

If ({RV_Practitioner.Last_Name} in ("A" to "C")) Then


{RV_Practitioner.Last_Name}


Else


"";

When it runs, it only gives me A to B (Cutting off C).. I can't seem to find away around this.. Any ideas?

I am running Crystal Reports v10

Thanks!

 

[Madawc]

Your test looks for a practitioner called "C". Try

If (Left({RV_Practitioner.Last_Name}, 1) in ("A" to "C"))

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10