Post reply

Easy multiply

  • September 14, 2009 at 1:44 pm

    #226131

    To multilpy TotalLoans X .06 do I use

    set @TotalC1 = ((@TotalLoans * 0.06))

    OR

    set @TotalC1 = ((@TotalLoans) * (0.06))

  • September 14, 2009 at 1:49 pm

    #1053432

    They have the same exact behavior, the parenthesis are optional around the equation, too. You could remove every parenthesis, and it would still do the same.

    P.S. Be sure the datatype of the column will have enough decimals to hold the result.

    Cheers,

    J-F

  • September 14, 2009 at 1:50 pm

    #1053433

    K, so either or works....whew!!

    Thanks Man!!

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

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