• What I am trying to accomplish is the following:

    Input: product ID

    Output: calculated value

    Process:

    Use input to look up up product information distributed across 3 tables. Do some calculations. The calculations create one final number. Return that number.

    I would love to have this as a function so that I can do something like the following:

    select Product.product, ufn_ship( product.product_id) AS shipnum, ....

    or @xyz = ufn_ship( 1234)

    Thanks for any help.

    Mike