Re: SQL*Forms 2.3 Help

In comp.databases.oracle.misc Sameer P. Tamane <stamane_at_kpmg.com> wrote:
: Hi,
: Need help on RIGHT ALIGNING a field (e.g. $$$ amount) in Forms 2.3 ??
: Can anyone please mail me or post the steps to achieve this ??
: Thanx in advance.

The value 123 right aligned using 5 char positions:

SELECT LPAD(TO_CHAR(123),5) FROM dual;

Hope that helps

--
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ Christian Mondrup, Computer Programmer                            +
+ Scandiatransplant, Skejby Hospital, University Hospital of Aarhus +
+ Brendstrupgaardsvej, DK 8200 Aarhus N, Denmark                    +
+ Phone: +45 89 49 53 01, Telefax: +45 89 49 60 07                  +
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++