On 27 Mar 2012, at 5:12pm, Alessio Forconi <forco...@gmail.com> wrote:
> is there a way to update a field in this way? > > Fieldtoupdate: > 1) Location: Rome. Location: New York. > 2) Location: Florence. Location: Tuscany. Place: Arezzo > > I want to update in this manner: > 1) Location: Rome. Lazio. > 2) Location: Florence. Tuscany. Arezzo Use the replace function <http://www.sqlite.org/lang_corefunc.html> to replace 'Location: ' with ''. Then put one location back in at the beginning of the string using || like this: 'Location: '||FieldToupdate Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users