oracle to_char FM099999 to_char(column,'FM099999')The FM in the format removes leading and trailing blanks.