Hello all,
I'm not sure if it's possible to do this using only SQL, so I'd like to ask: I need to add a column to a table which will be populated with data from another column in that table, but converted to lower-case. So, in pseudo-code I need to do this: ALTER TABLE MyTable ADD COLUMN LowerCase Let's say the schema becomes: MyTable(OriginalCase, LowerCase) So - something like the following: FOR EACH ROW IN MyTable UPDATE MyTable SET LowerCase = lower(OriginalCase); 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. Thanks in advance for any ideas and suggestions. Dennis _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users