I'm getting truncated values in the InsuranceCarrierName fields. I know why this is happening, the old whatever the first record's length is, then that's all you get for the rest. I added the PADR to get it all, but I really need the spaces trimmed between the field's value and the '|" character. How do I get around this?

SELECT ;
	TRANSFORM(InsCarr.InsCarr, "@T") + '|' AS InsuranceCarrierID, ;
	PADR(TRANSFORM(InsCarr.CarName, "@T"), 30, ' ') + '|' AS InsuranceCarrierName, ;
	IIF(Covr.CvPs == 'P', 'Primary', IIF(Covr.CvPs == 'S', 'Secondary', IIF(Covr.CvPs == 'T', ;
		'Tertiary',''))) AS InsuranceCoverage ;
	FROM Covr ;
	JOIN InsCarr ON InsCarr.InsCarr == Covr.CvCarr ;
	WHERE ;
		Covr.Pat_No = m.PtPn ;
		AND BETWEEN(DATE(), Covr.Eff_Date, EVL(Covr.Exp_Date, DATE(9999,12,31))) ;
	INTO CURSOR (ADT_IN1)