Hello Drew,

First off, thanks for the help as that worked perfectly. Secondly, i appreciate the insight to the correct use... I started a long time ago but don't...

I'm attempting to apply this to all companies but was specifying the company to try and fix in a smaller data set. So when I remove the where clause it...

YAY! Case statement in the order by clause! 
Perfect! Thank you. Let me validate it holds true when I plug it into the rest of it.