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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
