Re: Stored procs: detecting when SELECT returns no records

How about: let found = "N"; foreach select ..... let found = "Y"; exit foreach end foreach; if found = "Y" then and other versions on the same theme. Also this can be much more efficient as the engine does not have to return the full set only the first page. Cheers - Jim -- ----------------------------------------------------------------------------- Jim Gordon DHL Airways Inc. jgordon@us.dhl.com ----------------------------------------------------------------------------- My opinions are my own. They may vary with time but they remain mine!