Ian Hardingham <i...@omroth.com> wrote: > I'm just getting around to this. Can I do: > > ALTER TABLE userTable ADD upperName = upper(name) TEXT > > Will this retroactively and for all future inserts work?
This is not a valid syntax, so it won't work - neither retroactively, in the present, nor in the future. It's not even clear to me what you are trying to achieve here. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
