You have to do it manually. Or reconsider your database schema towards normalization.
Pavel On Fri, Apr 30, 2010 at 10:28 AM, David Lyon <david_ly...@yahoo.com> wrote: > If I had a table called TABLE with fields P1N......P50N is there a way to > select something like: > > "select P%N from TABLE" > > to return all the results from columns P1N......P50N or do I have to do it > manually: > > "select P1N, P2N, P3N, P$nN from TABLE" > > I can obviously do it via scripting but wanted a more elegant way. > > Thanks for your help in advance. > > > > _______________________________________________ > 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