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