Hello

I have a list of books in an SQLite database. I'd like to rewrite the
Price column so that:
1. When it says "US$ 1.12", turn this into "$ 1.12"
2. When it says nothing, the currency is actually in Euros, and
rewrite this as "€10,19".

Can SQLite do this, or should I write a script to perform this
rewriting?

Thank you.

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to