>>A friend of mine asked this to me today. I said yes,0 with confidence and he said OK then go and put that in Excel as a formula.
>>I thought it was an Excel bug but he turned and said it happens in SQL server with float datatype! I couldn't yet see that myself but trust his experience.
>>Any idea and solution?
>>TIA
>>Cetin
>
>I always enjoy this scanerio.
>
>If computer can not compute, then why are they called computers?

They can, and they do it much better than we can do using paper and pen. It's just the matter of infinite calculation... would you like to wait indefinitely for your computer to use up the known universe for memory just to add a few fractions?

And even if the problem is solved for fractions, there's still the slight problem of algebraic irrational numbers, and then transcendental numbers... you wouldn't want to wait indefinitely for a correct result. You want a result with negligible error in a microsecond - and you're getting it.

Now if programmers are not taught numeric maths... well, they should be.