Post reply

Function Required multiply

  • October 25, 2010 at 12:56 pm

    #230793

    Hi,

    I need a function that will multiply by 2 any odd numbers and any even numbers to multiply by 1.

    Example:

    Select fncMultOdd(7)

    Returns 14

    Select fnc(Multidd(2)

    Returns 2

    Thanks

  • October 25, 2010 at 2:34 pm

    #1241917

    Thanks, what does the operator % actually do though? Never seen it used in sql, well except as a Wildcard

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

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