Re: [sqlite] selective result columns

od already you better to tell > us what you're trying to achieve in general and what software you're > working with so that we could provide a better general advice that > doesn't involves such action as "removing columns without useful > information from result set"... &g

Re: [sqlite] selective result columns

I don't have access to that level of software, so that's the problem. Thanks for your response - I like the power of select case, and was hoping that case could be applied in other areas as well. Simon Slavin-3 wrote: > > > On 29 Dec 2009, at 8:34pm, nomorecaddy wrote: > &g

Re: [sqlite] selective result columns

Thanks, I'm looking for a SQL query that returns a variable number of columns. Many of my columns contain NULL data, and I want to avoid showing the column altogether in that case. Simon Slavin-3 wrote: > > > On 29 Dec 2009, at 6:29pm, nomorecaddy wrote: > >> Is it poss

[sqlite] selective result columns

Is it possible to run an SQL query in sqlite that displays columns only on a condition? For example: select col1, (case when 1==2 then col2) from myTable In this case, I only want to show one column (col1) Thanks -- View this message in context: