Post reply

limmit the decimal points

  • June 16, 2005 at 1:47 pm

    #66567

    HOW can I limit the number 1.2345678 to 1.23

    Thanks.

  • June 16, 2005 at 1:59 pm

    #566253

    If you're trying to round: Round(1.2345678,2). This returns 1.23. Note that Round(1.2356789,2) returns 1.24. Is that what you're after?

  • June 16, 2005 at 1:59 pm

    #566252

    either you choose DataType DECIMAL(12,2) for expl

    either you use

    CAST(MyNmb*100 AS INT)/100

    Kindest Regards,

    Vasc

  • June 16, 2005 at 2:01 pm

    #566254

    Nice SOLUTION with Round : )

    Kindest Regards,

    Vasc

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply