> What is the difference in the following two > commands? > DECLARE CURSOR..........WHERE colname IS NOT NULL > and > DECLARE CURSOR..........WHERE colname <> NULL > The first one gives me an error, the second one > seems to work.
The first one is correct. The second one will return every record, since NULL <> NULL is true and NULL = NULL is false (unless, of course, you have EQNULL set ON). -- Larry __________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
