Spesific order 1

[graabein]

Hi all,

I have a problem. I want to select a set of records from a single table and order them with the current user's records first (MAOL) followed by the others sorted alphabetically, i.e. like this..:

tName / tUser

Bill / MAOL
Chuck / MAOL
Jim / MAOL
Lucy / AMSK
Roger / ANFREM
Keith / INHE
Lisa / RABR
Peter / RASA
Kate / SOOYAS

I have tried several times with different combinations of UNION and ORDER BY. All help appreciated.

Regards,
graabein

 

[swampBoogie]

order by case tuser when 'MAOL' then 0 else 1 end, tuser

 

[graabein]

Excellent. Thanks alot! I am not very familiar with the CASE-clause.