"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))

>

Well, the cast doesn't work no matter what I do. I hate to have add a UDF
just for this. Are you sure this isn't a bug in FB 1.5 RC6?

>
> Helen
>

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