<--- --------------------------------------------------------------------------------------- ---- Blog Entry: Oh Baby, It's So Hot When You Paginate! (aka Paginating Results In ColdFusion) Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:281.view Date Posted: Sep 21, 2006 at 1:21 PM ---- --------------------------------------------------------------------------------------- ---> ORDER BY ( CASE WHEN b.id = THEN ELSE 0 END ) ASC