If you've struggled to understand analytic functions, this article is for you. http://www.quest-pipelines.com/newsletter-v7/0706_B.htm Quite good explanations. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist