No matter in which version, using Transform() and Trim() for creating a column in a SQL command is problematic, or wrong, since the column width will be determined by the data width of first output record. Information will be lost if data in subsequent records are longer. You may consider rewriting your statement as:

#define n 500 && or a number meets your need
SELECT Padr(bb, n) as dd from a1 INTO CURSOR c1