[EMAIL PROTECTED] wrote:
Witold Czarnecki wrote:
You may use operator "ISNULL" instead. For example "SELECT x FROM
table WHERE y ISNULL".
Best reagrds,
Witold
----- Original Message ----- From: <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Sunday, March 06, 2005 2:12 PM
Subject: [sqlite] Does sqlite has isnull function?
Hi All,
I don't think sqlite support isnull function, but I wonder is there
other function has same functionality but different name?
thanks,
Ming
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,
IFNULL worked! thanks Witold Czarnecki