• Is this what you need to do ?

    SELECT 2.86 /1 - 2.86 % 1

    SELECT 2.16 /1 - 2.16 % 1

    Result for both selects is 2.000000

    Note that the "%" is the modulo operator - check it out in BOL it is a powerful tool to become familiar with.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]