I have a table with multiple columns in it.
Currently I sort them by: ORDER BY (COL1 - COL2)
However, I need to sort only a part of the table like that. Therefor I would
like to do:
SELECT x, y, z from table ORDER BY
WHEN (y<z) then 'y-z'
However, this does not seem to work. Is this possible? Can sql server (2k)
sort subsets of data??