>Thanks for the quick response(s)...I haven't been using views, but now seems like a good time to get acquainted with them.
This is both worthwhile, and easy. For a start, a view is very similar to a cursor. Actually, I think you could say it IS a cursor. The only difference with traditional cursor is that changes can be written back to the underlying tables.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)