• Eugene Elutin (7/3/2013)


    6 - X formula will work for you:

    SELECT v, 6-v as converted_v

    FROM (VALUES (1),(2),(3),(4),(5)) v(v)

    Eugene - not sure how i would add this to the query. Can you elaborate?