-- PADR with spaces
CAST(oldvalue, CHAR(<NewLength>))
-- PADL with spaces
RIGHT(REPLICATE(SPACE(1),<NewLength>) + oldvalue,<NewLength>)