none
Round off with 4 decimal places

    Question

  • Hi

    I have Data with 3 decimals . need to round off with 4 as defalut.

    Ie:

    select value from table

    Default

    ----------

    1.123

    2.476

    I need as below

    1.1230

    2.4760


    ShanmugaRaj

    Tuesday, September 11, 2012 7:42 AM

Answers

  • see the e.g


    select cast(1.123 as decimal(9,4))

    vt


    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

    • Marked as answer by ShanmugaRaj Tuesday, September 11, 2012 7:47 AM
    Tuesday, September 11, 2012 7:43 AM