Lynn,
Sorry I did not reply to reply to your response. Your answer worked great. I responded to the other answer, because it did not make since to me why you would do more work than you needed. I am new to TSQL but his code looked like it was less efficient than my code. I was hoping I was missing something from his what he posted and that I was looking at something wrong. I am always trying to learn. Again think for your answer, it was exactly what I needed.