Thanks Drew,

I guess in a way I can be thankful it is not obvious...

I have been looking for a strategy and I did run into the quirky update but did...

Thanks for these responses. They have helped clarify the logic...and I like the UDF approach, but I am using SQL 7 and cannot create UDF's so I have adapted the temp...