"Gilles Ganault" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> 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".
What do you mean "nothing"? What exactly is the format of the number in
this case?
Anyway, you want something like this:
update mytable set Price =
case when substr(Price, 1, 2) = 'US'
then substr(Price, 3) else '?' || Price end;
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
