ORDER BY - mix two fields

[m.k.ball]

I have a table with business names and contact lastnames and
firstnames. Some records don't have a business name, and some don't
have contact names. Does anyone know whether it is possible to have
results sorted by business name, unless the field is empty, in which
case, use the surname followed by the first name in place of the
business name. i.e.

table: people
fields: business name, lastname, firstname

records:
"A to Z Spares", "", ""
"", "Naylor", "Bob"
''Zack's Auto" "Zachariah", "Brown"

ordered result:

A to Z Spares
Naylor, Bob
Zack's Auto

[Felix Geerinckx]

On 22/12/2005, m.******@btinternet.com wrote:

Does anyone know whether it is possible to have
results sorted by business name, unless the field is empty, in which
case, use the surname followed by the first name in place of the
business name. i.e.

....
ORDER BY
COALESCE(
IF(business_name = '', NULL, business_name),
CONCAT(lastname, firstname)
);

--
felix