I have a field that is float. I'm trying to change it to numeric(5,2) but
have a problem. I create a new field of type numeric(5,2). Then I do a
query:

update classsubject
set weight = cast(weight1 as numeric(5,2))
WHERE WEIGHT1 IS NOT NULL

The result is Field Weight is always rounded up. I must keep the 2 decimal
places.

Any suggestions?

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