Can't do CTEs sadly, SQL 2000.<br><br>I had thought about wrapping my results in an outer SELECT and using the CASE statements there.<br><br>But that seemed like a PITA.<br><br>So I thought about ...