Hi Don,

thought I'd throw my 2 cents worth in...
perhaps you could create an external file through Firebird
and write the "cast" values to it. If they come out as you wanted,
then you could re-select them from the external file.

Note, I haven't verified this, it's just a suggestion.

Mark

Thursday, January 8, 2004, 4:36:02 PM, you wrote:


DG> "Helen Borrie" <helebor@...> wrote in message
DG> 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

DG> numeric(5,2))

>>

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

>>
>> Helen
>>

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





DG> ___________________________________________________________________________
DG> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
DG> without the need for BDE, ODBC or any other layer.
DG> ___________________________________________________________________________
DG> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
DG> keyword-searchable FAQ, community code contributions and more !

DG> Yahoo! Groups Links

DG> To visit your group on the web, go to:
DG> http://groups.yahoo.com/group/IBObjects/

DG> To unsubscribe from this group, send an email to:
DG> IBObjects-unsubscribe@yahoogroups.com

DG> Your use of Yahoo! Groups is subject to:
DG> http://docs.yahoo.com/info/terms/