Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Command
- Thread starter BigDude
- Start date
BigDude, I was recently given a description of how boolean algebra permeated the world of Basic programming. It came from our 'Science Officer' :
and it was enlightening.
In VB, VBA, Jet, SQL Server, and others the symbol for "not equal" is "<>", ....except when testing for 'null' in which case other syntax is employed.
In SQL the syntax would be 'is not null' or 'is null'.
As in, ".. SELECT FROM table1 WHERE value1 is not null...".
If "!=" represents not equal in your world as I suspect is the case from what you indicated, then you understand why null requires special treatment.
Live long and prosper, dude.
Amiel
amielzz@netscape.net
and it was enlightening.In VB, VBA, Jet, SQL Server, and others the symbol for "not equal" is "<>", ....except when testing for 'null' in which case other syntax is employed.
In SQL the syntax would be 'is not null' or 'is null'.
As in, ".. SELECT FROM table1 WHERE value1 is not null...".
If "!=" represents not equal in your world as I suspect is the case from what you indicated, then you understand why null requires special treatment.
Live long and prosper, dude.
Amiel
amielzz@netscape.net
- Status
Similar threads
- Locked
- Question
