Thanks to all. I will test the CASE option as well as the view. The temp table could be an option later. I created a store proc this morning and will test that one too. Thank you again.