The LFILL or RFILL function can be used to pad CHAR-type values with any character up to a specified length.
SELECT LFILL(firstname,' ',8) firstname, name, city
FROM customer
WHERE firstname IS NOT NULL AND
city = 'Los Angeles'
EXPAND expands a character string by a specified number of blanks.