Alessio Forconi <forco...@gmail.com> wrote: > I tried this way but it does not work > > UPDATE September Notes Recipes = Replace (Notes, | |, 'Location:')
UPDATE MyTable set Notes = 'Location: ' || replace(Notes, 'Location: ', ''); -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users