case order by sample Posted by Albert 4925Day 5Hour 20Min 8Sec ago [2012-06-19] SELECT * FROM XXTABLEORDER BY CASE COLUMEWHEN 'AA' THEN 1WHEN 'BB' THEN 2 WHEN 'CC' THEN 3 ELSE 100END LIST