Hi Skip, > I'm not sure what you mean by what is below:
>> mode insert >> select * from bsp_options where modelID=351; >> > Is that two separate SQL statements? I'm testing all this using the > SQLiteAdmin tool, so do I paste > what you have above in the SQL window? I tried that and got an > "error near mode" back. Sorry, I left out a dot. It should be: .mode insert select * from bsp_options where modelID=351; You enter tat using the command line tool. It will reveal the insert statements used to create the data, which will show the years as either 1990 (numeric) or '1990' (text). Tom BareFeet http://www.tandb.com.au/sqlite/compare/?ml _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users