my $price = '23,356.00'; my $itemref = 'S10099'; my $query = "UPDATE items SET price=? WHERE itemref=?;"; <--- $sth = $dbh->prepare ( $query ); $sth->execute ( $price, $itemref ); <--- $sth->finish ();