Home Forums SQL Server 2005 T-SQL (SS2K5) How to trim the decimal places? RE: How to trim the decimal places?

  • September 18, 2008 at 4:57 pm

    #873964

    You could use the CONVERT function for example:

    DECLARE @Num4 AS DECIMAL(10,4)

    DECLARE @Num2 AS DECIMAL(10,2)

    SET @Num4 = 1234.9876

    SET @Num2 = CONVERT(DECIMAL(10,2),@Num4)

    SELECT @Num2

    @Num2 will then equal 1234.99 -- note the rounding which has taken place.

    of course this works as well

    DECLARE @Num4 AS DECIMAL(10,4)

    DECLARE @Num2 AS DECIMAL(10,2)

    SET @Num4 = 1234.9876

    SET @Num2 = @Num4

    SELECT @Num2

    @Num2 will then equal 1234.99 -- note the rounding

    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]