I tried this way but it does not work
UPDATE September Notes Recipes = Replace (Notes, | |, 'Location:')
where is the mistake?
> 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.
Alessio Forconi
Il 27/03/12 18:12, Alessio Forconi ha scritto:
Hello everyone,
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
It can be done with a query?
Thank you.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
