I also cannot think of a way to do this without naming columns. If this is something you have to do frequently from multiple locations, it might be worth creating a view that does the hard work in one place.
On Wed, May 11, 2016 at 10:29 AM, Simon Slavin <slavins at bigfraud.org> wrote: > > On 11 May 2016, at 11:26am, William Drago <wdrago at verizon.net> wrote: > > > Is there a simple way to find a row in a table where none of columns > contain a null value? For example: > > > > SELECT * FROM AnyTable WHERE (all columns IS NOT NULL) LIMIT 1; > > The coalesce(a,b,c, ...) function returns the first of its arguments which > isn't NULL. If they're all NULL it returns NULL. So it sort-of does what > you want, but you will have to list the column names. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Scott Robison
