Hello All,

I was wondering if anyone has run across this... We have been
pulling our hair out for some time with this...

When converting a money field from Sybase 11.0.3.3 SWR 7930 Rollup
to SQL 7.0 using a standard DTS transformation, if the value of the field ends with "0.00", the zero(s) to the left of the decimal get truncated ...

Examples ...

Sybase SQL 7.0

1234.00 1234.00
1230.00 123.00
1200.00 12.00

Anyone else seen or experienced this??

Thanx!
Bob