Re: [sqlite] Does sqlite has isnull function?

Sun, 06 Mar 2005 05:30:45 -0800 

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: <[email protected]>
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,

Reply via email to