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