Re: find any row with NULL

2016-07-09 Thread Hal.sz S.ndor
2016/07/08 09:15 ... 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:-) Well, one could try this: set @sel=(select 'SELECT ' ||

Re: find any row with NULL

2016-07-09 Thread william drescher
On 7/8/2016 9:15 AM, Johan De Meersman wrote: As a clear example of what it is useful for, imagine a situation where you're performing an inventory on an existing warehouse. You have the list of all the products they've ever sold, but you need to differentiate between 'this product is not in