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