Post reply

Round a price

  • August 18, 2009 at 11:40 am

    #134875

    I’m trying to round a price to 2 decimal places. I have ROUND(MIN(ext_PriceClass.Price), 2) AS price in the query statement, but it’s not working. Is there something else I should be using

  • August 18, 2009 at 11:43 am

    #1041043

    Have you tried casting as decimal?

    DECLARE @p float

    SET @p = '15.4'

    SELECT CAST(@p as decimal (8,2))

  • August 18, 2009 at 11:47 am

    #1041045

    no, how would I get ext_PriceClass.Price Thank you

  • August 18, 2009 at 12:16 pm

    #1041069

    Krasavita (8/18/2009)

    no, how would I get ext_PriceClass.Price Thank you

    ... umm.. not sure I follow you there. That would be the field selected in your query?

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

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

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