you can use mathematics in the order by clause .
See the following hypothetical example on the northwind database.
declare x int
select x=count(*) from orders
select employeeid * x,employeeid from orders order by employeeid * x
"Johan Ryberg" <com> wrote in message