>Thanks!
>
>>>Boris,
>>>
>>>where is the SQL button?
>>>
>>>>>Open table - similar to BROWSE, but you can't set an order so it's difficult to find things
>>>>
>>>>
>>>>Frank,
>>>>After you open the table that way you could click on SQL button and change the SQL statement and run that SQL.
>>
>>When you open table for editing (Right Click on table and choose "Open Table") new toolbar must appear. In that toolbar there is a button with SQL in it. If it doesn't show: View->Toolbars->Query Designer

BTW there are a lot of other tools which could do that for your. One comes to my mind is TOAD for SQL Server. BUT because I just try it not use it for my everyday job, I am not sure if you could open table for edit. But with it you easily can sort and group the query results. They have free version also, not sure what it could do, but you could download it and play with it (I definately would do this if I have some time)