Currency Type

[nengie]

Hi all,
I just wonder about currency and numeric field type.
Just try....
? 41379 * 0.36099 the result is 14937.40521
but...
? NTOM(41379) * 0.36099 the result is 14937.8190

How come ? TIA

 

[rgbean]

See the MS KB article "PRB: SET DECIMAL Limited to Four Decimals in Currency Data (Q192961)" -

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q192961

for an explanation.

Rick