Hi Asbjørn, try to use "replace" function: http://www.mysql.com/doc/en/String_functions.html
update YourTable set YourMoney = REPLACE('255,55', ',', '.') where ... ; Best regards, Mikhail. ----- Original Message ----- From: "Asbjørn Konstad" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 12, 2004 11:33 AM Subject: Storing currency values Hello. I've spent some day(s) probing the web to find a solution to this problem: A table-column for storing currency -> float(10,2). As my users are punches the currency value like this "255,55", with a comma as decimal point, MySQL stores this value as zero (0.00). I quess the reason for this is that MySQL uses "." as decimal point for float-types (or any decimal value). Does anyone know of a workaround for this problem??. Is there any way of changing the decimal separator in MySQL?? Reg. A Konstad --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02.01.2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]