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