Doh!
Ok, sorry for that. I wish Foxpro gave better error feedback. It knows what's wrong, why not tell us?
Thanks!
>Missing a quote after Other.
>
>>This is a line from a SQL statement. I keep trying different things with parenthesis moved around, but I keep getting a compile error. Anything obvious? Forget that I don't need TRANSFORM on this line, but I will need it on other similar ones.
>>
>>
>>PADR(THIS.Strip(TRANSFORM(IIF(Covr.Cvt='01','MediCare',IIF(Covr.Cvt='02','MediCaid','Other)), '@T')), 30, ' ') ;
>> AS IN1_15_00_Plan_Type, ;
>>