Roy,

That's really handy, and I think I'm going to steal the idea - mainly
because of the order by issue.
Out of curiosity, why you do prefer to use a cursor, etc.. instead of
the exception block? Is it faster?

--
Fernando Dias
[Team Elevate]

Fernando

>Out of curiosity, why you do prefer to use a cursor, etc.. instead of
>the exception block? Is it faster?

No idea on speed. I've never tried a comparison. Firstly I prefer not to use exceptions where I can avoid it, and secondly it seems more consistent with my approach in Delphi when building a script etc.

Roy Lambert [Team Elevate]