6 - X formula will work for you:
SELECT v, 6-v as converted_v
FROM (VALUES (1),(2),(3),(4),(5)) v(v)
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]