>
Nice point. But, from the standpoint of n-tier design, shouldn't ORDER BY be a UI tier choice, rather than a data tier choice?
<

I don't know, you tell me. Construct the argument for why it should be specified at the UI. Specifically, construct an argument as to why n-tier design should drive this decision. How would you employ the solution? I have some thoughts on this, but I would like to see yours first - since you brought it up.

< JVP >