Oh, that looks simpler than I thought. Thank you for the reply! Dennis
-----Original Message----- From: Steven Fisher [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 05, 2008 10:50 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Is it possible to do this using only SQL? 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
