No, you have to pad whole expression. You cannot avoid trailing spaces because VFP8 and ealier do not support varchar fileds.
PADR(TRANSFORM(Patient.PCare_Phy, '@T') + '^' + TRANSFORM(RefProv.LAST, '@T') + '^' + TRANSFORM(RefProv.FIRST, '@T'), 50)
>This is what I used when there was one field:
>
>
>PADR(TRANSFORM(InsCarr.CarName, '@T'), 30, ' ')
>
>
>But now I'm getting truncated values in the individual fields in this SQL:
>
>
>TRANSFORM(Patient.PCare_Phy, '@T') + '^' + TRANSFORM(RefProv.LAST, '@T') + '^' + TRANSFORM(RefProv.FIRST, '@T')
>
>
>Do I have to pad each one? I'm sure I do, but what I really need is the trimmed values in the resulting field. Like "000001^Johnson^Donald" not "000001^Johnson ^Donald " if that made sense (I typed 5 spaces before the "^" but the UT parser ignored 4 of them).
>
>
>>Pad whole expression not part of it
>>PADR(TRANSFORM(InsCarr.CarName, "@T") + '|', 30) AS InsuranceCarrierName,
>>
--sb--