Simple Order By query?

[redgenie]

I'm trying to perform a select that orders the results alphabetically yet always puts a specific one last.

Ie.

Fred, Jane, Sharon, Tracy, Bill

I always want Bill to be last even though the rest are in alphabetical order.

Any help would be greatly appreciated.

Something along the lines of:

select Name from People order by Name, 'Bill';

 

[KenReay]

Hi

How about something like

SELECT * FROM MyTable ORDER BY IIF([FirstName]='Bill',"ZZZZZZZZ",[FirstName])

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[LittleSmudge]

I use something like :-

SELECT Name, 1 As SO FROM People WHERE Name <> 'Bill' 
UNION
SELECT Name, 2 As SO FROM People WHERE Name = 'Bill' 
ORDER BY SO, Name;

( SO stands for SortOrder - You can use any name you like )




'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[redgenie]

Great, thanks guys. That works very well