Re: Forms 4.5: How to store/display leading zeros?

For displaying in a form try using the format mask: 000 or 00. For 6 this will show 006 or 06.
But, you can't store a 6 as 006 or 06 in a number column, only in a varchar2 column.

-Eric

Barry Prentiss wrote:

> Hello Oracle Fans,
> I am new to Oracle, Oracle Forms and SQL & PL/SQL. I have a problem
> where our dwg numbers are segmented into multiple fields (ie. PREFIX,
> SERIES, BASE, AND SUFFIX), the last three fields are NUMBER fields. How
> do I store and display leading zeros?
> EX: dwg no: SA-001-002-03 displays SA-1-2-3.
>
> Thx in Advance...
>
> --
> _____________________________________________________________
> Barry Prentiss Software and Systems Design
> (650)926-3812 Stanford Linear Accelerator
> thebear_at_slac.stanford.edu Stanford University
Received on Tue May 19 1998 - 00:00:00 CEST