In article <41DD1C69.1080802@...>, Michal Žeravík wrote:

> Sorry, can't understand.
> what is column number?
> As I said :
>
> SELECT
> n.*,

I can't tell you the number because you have n.* And I don't know how many
columns that is but

select col1, col2, col3 from atable order by 3 will order by the contents of
col3

--
Nick (remove 1 to reach me)
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly