On 04-Feb-2008, at 3:41 PM, Dennis Volodomanov wrote: > Is that possible? If not, I'll have to do it in the code, but that > will > probably be slower and I'm expecting to have tens of thousands of > rows.
Sure: sqlite> create table x(a); sqlite> insert into x(a) values('ABC'); sqlite> insert into x(a) values('DEF'); sqlite> alter table x add column b; sqlite> update x set b=lower(a); sqlite> select * from x; ABC|abc DEF|def sqlite> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users