Hi all
I'm trying to bring a monetary value from an Oracle server into an SQL 2000
environment. In the oracle table the monetary value displays with two
decimal places but when viewed in the SQL table it has rounded to no decimal
places. It does not matter what data type I use when bringing it into SQL it
always rounds to no decimals.
Has anybody had any similar problems?
Thanks

Did you try :

select convert(money,(replace('0.44','.',',')))

--
Message posted via http://www.sqlmonster.com