Thank you both! I'm only using sql server 2005 so we are on the right track. I need to join to this query as part of a bigger query....