------------------------------ Commands Entered
------------------------------
SELECT qty AS Qty_13
, SUBSTR(INSERT(CHAR(DEC(qty,9,1)),2,1-INT(SIGN(1+SIGN(qty))),'')
,1,10) AS Qty_10
FROM (SELECT CAST(src AS DEC(13,3))
FROM (VALUES 12.900, -12.900, 10000000.000, 0.000,
12345678.999, -2345678.999) Q(src)
) R (qty);
------------------------------------------------------------------------------
QTY_13 QTY_10
--------------- ----------
12.900 00000012.9
-12.900 -0000012.9
10000000.000 10000000.0
0.000 00000000.0
12345678.999 12345678.9
-2345678.999 -2345678.9
6 record(s) selected.