That's the way I roll :cool: I agree there's no need. If it's a once-off, I would just use the CASE expression. However, if you need to do this...
If anyone is reading this, a better answer to the above would be: select Col1, Col2, CASE WHEN (Col1 > Col2) THEN Col2 ELSE Col1 END AS Lowest FROM...
Separate names with a comma.
