>Hi,
>
>what is the best way to 'force' SQL to formatt a numeric field to a certain width and decimals? For example, suppose I have QTY as 14,4 field and PRICE as an 14, 4 also. when I do a select QTY * PRICE as TOTAL, it ends up as a 20, 4 field when all I may really want is another 14,4 or even a 10,2 depending on what I'm doing. This gets even more complicated when using UNION between varying length fields in different cursors.
>
>Ideas?
No ideas, just old Indian tricks:
select 000000000.0000+qty as qty, etc, etc.
This works ever since 2.0