Post reply

ROUND / TRUNCATE WITH REMOVAL OF ZEROS

  • November 24, 2011 at 1:17 am

    #247390

    Hello,

    Is it possible to round and then truncate a number and then remove all of the zero's?

    PRINT ROUND(12.3456789, 4, 0)

    12.3500000

    PRINT ROUND(12.3456789, 4, 1)

    12.3400000

    The result I'm after is 12.35 (without the zeros).

    Thanks for any help in advance.

    -Marisa

  • November 24, 2011 at 1:25 am

    #1412575

    take a look at cast and convert functions, they can manipulate the data into a decimal value with what ever precision you give it.

    EG

    PRINT CONVERT(DECIMAL(10,2),ROUND(12.3456789, 4, 0))

  • November 24, 2011 at 5:27 pm

    #1412825

    Thanks Anthony,

    I have some fairly complex statements and this works a treat.

    Cheers, Marisa

  • November 25, 2011 at 1:24 am

    #1412872

    not to worry, always happy to help.

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

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