I'm not following? Wait a minute... I think I see... I'm going to try that, hold the phone.
>Yes, something like that. You may have to specify ORDER BY by column # if SQL Server complains. You can also get rid of that additional column using current query as derived table
>
>
SELECT Empid, EmpName, OverTime, DoubleTime, TotalHours1 FROM (
> -- your select here
> -- Order by column position instead of names
> ORDER BY 1,6
>) dt1
>
snip...
>>snip...
Thanks
Jon
Non-MVP Non-MCP Non-MCSE
Visual FoxPro, What else is there?