Re: using to_char

From: Mabel Triguis <mabel.triguis_at_unctad.org>
Date: 1998/03/24
Message-ID: <6fajeq$vvp_at_iccuc2.unicc.org>#1/1


Hi Vinod:
The space correspond to the relevant sign of the number (+- or -) . Regards,
Mabel

Vinod Nair wrote in message +ADw-35170607.1A80+AEA-polymerland.com+AD4-...
+AD4-While using to+AF8-char(1234,'00009') for formatting the number , the length
+AD4-of the output comes out as 6 , instead of 5 (00009) .The output I want
+AD4-is '01234' , but the output generated is ' 01234' .I can use ltrim and
+AD4-take away the space , but is there any reason why this should happen ?
Received on Tue Mar 24 1998 - 00:00:00 CET

Original text of this message