order by instead of two queries

[Leonardo B Lopes]

I have some data in a table that I would like to obtain order by a
specific instance of the data. ex:

Name:		Age:

Joe		50
Jill		60
Jack		65

What I would like to do is have a query that returns Jack first, then
the regular name order. Something like:

SELECT Name FROM clients ORDER BY Name='Jack',Name

Can this be done with one query?

Thanks!
Leo.
-- 
=======================================================================
Leonardo B. Lopes                                      leo at iems.nwu.edu 
Ph.D. Student                                             (847)491-8470
IEMS - Northwestern University             http://www.iems.nwu.edu/~leo