Subject Float to Numeric
Author Don Gollahon
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

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

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

Any suggestions?

Don Gollahon
ICQ#: 115831669
"What in Eternity does it matter?"

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