bgsxygrmn
Thanks, but that doesn't really help me at all. I think that I would have to combine two of the functions that are listed in the link.
Do not understand your:
that doesn't really help me at all.
You want someone to give you the complete T-SQL statement?
Remember People here help those who help themselves
Please read the first link in my signature block for the correct procedure to post a question, paying particular attention to table definition, sample data, expected results and what you have done