This is untested, but would val(str(qty*price, 14, 4)) return the proper digits?

>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 ....