"Helen Borrie" <helebor@...> wrote in message
news:<5.2.0.9.2.20040108163551.04269a70@...>...

> At 10:07 PM 7/01/2004 -0600, you wrote:
>
> Try this:
>
> update classsubject
> set weight = cast (cast (weight1 * 100 as numeric(7,2)) / 100 as

numeric(5,2))

>

I finally got it. I changed the type of Weight1 from Float to Double
Precision (a simple cast wouldn't work) then I did the update statement of
my first message.

>
> Helen
>

_________________________________________
Don Gollahon
dlgllhn@...
ICQ#: 115831669
"What in Eternity does it matter?"
_________________________________________