> I don't have access to that level of software, so that's the problem. You mean your experience with SQLite is based on using sqlite3 command line utility only? If so you can just redirect its output to sed which will do something like s/|\+/|/g. If your experience with SQLite is based on using some other kind of software then you cannot do anything with it - it will inevitably rely on the fact that each row has the same number of columns and it will show you all of these columns...
In any case as you probably have understood 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"... Pavel On Tue, Dec 29, 2009 at 4:34 PM, nomorecaddy <nomoreca...@yahoo.com> wrote: > > 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: >> >>> 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. >> >> That is something that must be handled by your software. There is no way >> in SQL to return an answer to a SELECT which has a different number of >> columns in different records. You could make SQL return columns with NULL >> in and your software could automatically recognise them and know not to >> print them. >> >> Remember that SQL is a database engine. It's job is to supply data. It's >> your software's job to understand what needs to be done with it. >> >> Simon. >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> > > -- > View this message in context: > http://old.nabble.com/selective-result-columns-tp26958131p26960765.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
