Stefan Schwarzer wrote:
SELECT * FROM gdp WHERE y1970 NOT NULL AND y1971 NOT NULL AND
.... y2005 NOT NULL
I would like to have this:
SELECT * FROM gdp WHERE all-fields NOT NULL
Well you can get closer:
SELECT * FROM gdp WHERE (y1970+y1971+...+y2005) IS NOT NULL;
This makes use of the fact that X+NULL = NULL
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
