| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Please Help! Formatting Numbers with Leading Zeros
On Mon, 24 May 1999 15:25:26 -0700, Sussette Blasa
<stblasa_at_earthlink.net> wrote:
>Hi--hope somone can help...I've been trying to find a way to format
>postal/zip code. The field is a number datatype. For example the postal
>code for Westport, CT is 06880. However, when a run a query like this:
>
>SELECT POSTAL_CODE FROM DEALER_TABLE
>WHERE CITY = 'WESTPORT'
SELECT TO_CHAR(POSTAL_CODE, '00000') FROM DEALER_TABLE
WHERE CITY = 'WESTPORT';
Received on Tue May 25 1999 - 04:52:30 CDT
 |
 |