Re: sql scale, decimal, help..

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Tim

If I understand this, try dividing by 100.0 - might need to cast one of the
operands with the decimal() function.

HTH

Vern

At 03:58 PM 12/30/02 -0800, you wrote:
> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
> --
> [ Picked text/plain from multipart/alternative ]
> I have an integer 100, but it really represents $1.00  Is there an sql
> function I can use on the update, to force/cast/convert it to two decimal
> places?
> update exdbfa/expplvhtim set vhvexp = 100
>
> But I really want to to be:
>   update exdbfa/expplvhtim set vhvexp = 1.00
>  but I don't have the ability to manipulate the variable, before the SQL
> command, I can only altar the update statement...
>
> my db2 field is defined as 17,2  so it can can handle the data correctly...
>
> thanks, tim