On Wed, 16 Oct 2002, Albrecht Berger wrote:
> Hello,> I have a statement like this :>> INSERT INTO tab1 (c1, c2, c3) VALUES (1,2, SELECT MAX(pos)+1 FROM tab2);
Coalesce is your friend. :)
Coalesce((select max(pos)+1 from tab2), 0)should work.