Fred,

That great for 'expanding' the format, and I do it like that where I can, but unfortunately, that method doesn't work for narrowing the format down, and that's what I need.

Ken

>>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?
>>
>>Thanks!
>>Ken
>
>Add a 0 value in the format you want:
>
>SELECT (qty*price)+00000000000.00 AS total ....