>so how about
>
>SELECT STRTRAN(fieldname," ","")+SPACE(nn-LEN(ALLTRIM(fieldname))) AS fieldname FROM tablebname
>

How about m.nn = fixed field length for fieldname

m.nn = len(tablename.fieldname)
SELECT PADR(STRTRAN(fieldname," ",""),m.nn) AS fieldname FROM tablebname