Inserting Money Types

Hello-

I am running postgres 8.0.8 on a Gento system and am having trouble updating a column of type money (yes, I know it's depricated but I have to work with an existing database). When we do the initial INSERT statement and pass in a float it works fine, but I am writing a routine that takes values from a varchar field of another table and attempts to update the money field and I am told I need to cast it. When I attempt to cast it I'm told that I can't cast a char to money, float to money, or numeric to money!

Is there any way I can get this char value to UPDATE into a money datatype? If not, we may have to convert our tables to use numeric, but that will be a very big deal.

Thanks for your help

Greg Lindstrom