Stacking of 'when' statements in 'Order By', 'Group By' statements
The 2..99 'WHEN's should lineup
<code>
.....ORDER BY
..........CASE WHEN intSortField = 0 THEN ContractDashZone
....................WHEN intSortField = 1 THEN ContractNameAndContractCode
END;
</code>
3
votes
![](https://secure.gravatar.com/avatar/f93ab26d5b72aec63e79084a1d9d5c91?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
LSTemp commented
http://www.devart.com/ru/forums/viewtopic.php?t=13080
russiancode formating is must be more customisable -it fact.
+1
PS
but no vote at THIS time. mb later