sql trouble

[tbobker]

Hi, i have this query:

select sno, fname&" "&lname as name, address, tel_no, position, sex, dob, salary, nin, bno from staff order by salary desc;

it contains all the fields in the table, but i wanted to have the fname and lname as on column, how can i do that but not have to write all the fields out?

[scrupul0us]

it might just be worth your while to just do select * from Staff order by salary desc; and then in php just combine the name