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, ;