 <p>consider each part of the order by as a different column... Apply a case to each component. Get the first part first... then the second part. If it doesn't apply to the second part, just have it always the same value... something like...</p> <pre><code>ORDER BY CASE WHEN PortalName = 'Company, Inc' THEN 1 WHEN PortalName = 'Setup' THEN 2 WHEN PortalName = 'Daily Routine' THEN 3 WHEN PortalName = 'Master Option' THEN 4 ELSE 5 END, CASE WHEN IsActive = 1 THEN 1 ELSE 2 END, PortalName ASC </code></pre>