Hi Andrew, Thanks a lot. it really worked very well. Sanjeev On 10/26/07, Andrew Ballard <aballard@xxxxxxxxx> wrote: > > This should work: > > ORDER BY CASE WHEN id = 3 THEN 0 ELSE 1 END, name > > Andrew > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Warm Regards Sanjeev ------------------------------------------------ http://www.sanchanworld.com/ http://webdirectory.sanchanworld.com/ - Website submission http://webhosting.sanchanworld.com/ - Webhosting solution provider