Text formatting To convert numbers to text: SELECT to_char(1, 'FM09'); Using FM to avoid the system adding a blank space before the number