Mr. Dubois, I owe you a beer!

Thank you for your input.. that was quite easy, I'm boggled I had not seen that solution my self!

I've added u.FullName ASC, u.UserName ASC...

LutzM (8/10/2010)

---

With your current design it's close to impossible (unless you're going to use some delimited strings): you have two variables (@SortBy and @SortDirection) and you want to have more...