To all who replied, thanks for all the help.

Naming the columns in not a problem. It's easy enough to get the column names 
and build the appropriate select statement.

Thanks again,
--
Bill Drago
Staff Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / William.Drago at L-3COM.com


> -----Original Message-----
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-
> bounces at mailinglists.sqlite.org] On Behalf Of Scott Robison
> Sent: Wednesday, May 11, 2016 2:17 PM
> To: SQLite mailing list
> Subject: Re: [sqlite] How to get 1 row with no null columns
>
> 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
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.

Reply via email to