Seems to me you're asking about SQL, and Sergey and Hilmar are thinking in terms of VFP's SET ORDER command. What Sergey said still sort of holds though. You can do
Select field1+field2, field1, field2 where ... order by 1
Alan
>Is it possible.
>I want to order by a field nad inside that another filed, just like
>select-sql SELECT ...WHERE...ORDER BY 1,2
>
>Thanks!
>Pablo