I *believe* that the "where" is applied first and therefore your pt_prgm_term_overall_end_date would not have any meaning when execution begins. This seems to confirm the same and suggests a strategy: http://www.blogger.com/comment.g?blogID=12997951&postID=113159789959160850 keith -- Keith Casey CEO, http://CaseySoftware.com