[EMAIL PROTECTED] wrote:
<snip>
FYI:
The function, as defined in ANSI, you are looking for is COALESCE ....
select COALESCE(MAX(SubOrder), 0)+1 from Table1 where ...
This is supported in sqlite3 (and I guess sqlite2)
Eddy
What I want to do is:
select ISNULL(MAX(SubOrder), 0)+1 from Table1 where ... anyway I can do this, since isnull is not working this way.
Thanks,
