Re: find any row with NULL

2016-07-08 Thread Johan De Meersman
You will have to repeat all the column names - no wildcards in where clause fieldnames - but the clause you're looking for is WHERE field IS NULL. Or IS NOT NULL if you want those :-) Remember, NULL is a special value that is not the same as zero or the empty string; nor to itself: NULL != NUL

find any row with NULL

2016-07-08 Thread lejeczek
hi there, I've been searching the vastness of the net but cannot find - how - to get all the rows with a NULL. And like any novice I wonder if this can be done without reiterating all the columns names(not manually at least)? Some expert would say it is easy, how easy is it? with an examp