Gianluca Sartori (4/8/2010)

---

This should do the trick:

ORDER BY CASE WHEN ISNUMERIC(ver) = 1 THEN 'ZZ' + ver ELSE ver END DESC

Hope this helps.

Gianluca