-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I have a table of UPCs with lengths varying from 6 to 12. I'd like to print those with length=10 to a file for printing. SELECT * FROM UPCs WHERE LENGTH(UPC)=10; works just fine. But when I export the table I naturally get the whole table. Would a View help here? Or create a temporary table. I believe there's a simple solution, but it eludes me. For now.
Ted - -- +-----------------------------------------------------------------+ | 3.14159 26535 89793 23846 26433 83279 50288 May the Spirit | | 41971 69399 37510 58209 74944 59230 78164 of pi spread | | 06286 20899 86280 34825 32411 70679 82148 around the world. | | 08651 32823 06647 09384 46095 50582 ... PI VOBISCUM! | +-----------------------------------------------------------------+ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQIcBAEBAgAGBQJMdTFKAAoJENEtY9EvFm6JUsoP/2yv45tWN+a9iZeI0OT7Ny5J rGf8/E6S9m11i87DZxFAw0wctjDjQIN0zwNqBVcsX1C32LtxK0MmoY0smsrOeLfE neLx2NifFUnsLvXlDcbKeCtDyHaGFhMQqC1EigUeCvqqopMBAEIzha//nlwQk036 alwC+Fs+rI59194/aRvQmR4IAhnl4byQ39Adjb/2/cbnt4/nlUQG1XLLidMdelpM tLeLE4ivUYoGOYwmN3jmRnAHwPlW53YiXkx++vU3CIFVZtyHNhnxzyWHZtLyYIWJ rOBZ/WyOXEqLvh9jqWqQ1Dy22Tr4Nyrw+QOoTPx6U8tLHBd2gdESYQDwKHIHpD1j 99FiboC3O/IwZ5hyfheC94bk53XsGlL8x/VIL+ia1ORIL80DL84cASBsqU0MoMsM fW5Fh1bVyms7sz89IfOnZt3dOC1Vuk4aqt4rdRb7AFtIGI8wdSeoZAodhdUu5xsd uq0twEngryFp4nycHBsu+jwxTYO0PX35sIPDKVLp3hZtAoblFhYsyjmjQBbxMaAB TYzzfhlE0KANo+DYzq0YioafFIkd4qW4Wg734znpKjjZY7kDsxeN2LYIdueoaGzt MziIprBqcq8gfcnBqA4WlX19LD6trb8jsR78hlqdJskYBUaqXvWz0/qjzxh6qvRX yritK3uMqSsasn4vdUPM =yJdP -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
