Subject: SQL syntax

From: [email-masked]
Date: Wed, 10 Jun 92 16:36:21 -0700

I knew I was in dangerous waters...

I said:

> ... I believe sql (gulp - i hope i get this right)
> defines something like the keywords 'ISNULL' and 'NOTNULL' that appear after
> expressions:
>
>        where reln.attribute ISNULL
>
> or:
>
>        where reln.attribute NOTNULL

and it should have been...

> Actually, SQL uses "IS NULL" and "IS NOT NULL".
>
> e.g.:
>	SELECT emp.*
>	 WHERE emp.name = "Jeff"
>	   AND emp.heartswins IS NOT NULL;
>

Jeff Meredith
[email-masked]