Of course it's possible, it's almost exactly as your pseudo-sql Greetings!
Dennis Volodomanov escribió: > 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 > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
