Sorry about the double post but after 4 days of no response in the other
newsgroup I decided to come here since I'm going to do this with IBObjects
anyway:

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 weight 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?"
_________________________________________


[Non-text portions of this message have been removed]