Brilliant. Thanks. rudy wrote: > > what other options do I have for implementing > > this sort of iterative sub-select? > > rule number 1 -- never do in code what the database can do in sql > why not save the results in a temp table in the database? -- mike[at]nthwave.net