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