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