On 16 Jun 2011, at 5:27am, BareFeetWare wrote: > There could be dozens of each but the main issue is that I don't know what > they are until I get the data. That's what I meant by: > >>> I don't know all of the parts (ie "Silo Group" and "Region") until I bring >>> in the Import. > > So I can't completely populate lookup tables before I bring in the Import. > There will be a new Import periodically which might contain new Silo Groups > and Regions, and I won't be able to manually add those to the lookup tables > before importing.
Sorry. It could be done by matching 'A', then matching 'B', etc. but the results would be horrible. I recommend you do it in your programming language, which should be able to spot the first capital letter much more easily than SQLite. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
