>Just wondering if anyone run into the following problem:
>
>INT(1333365.89000*100) return 133336588 this should be 133336589
>INT(333365.89000*100) return 33336589 expected
>INT(11333365.89000*100) return 1133336589 expected
>
>Does anyone have any ideas why the first scenario the last digit is different?
>
>Thanks !
Ttry INT( ROUND(1333365.89000,3)*100)
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.