Hi, to convert '16.00' to 16.00, you can use select '16.00'+0 mysql> select '16.00'+0; +-----------+ | '16.00'+0 | +-----------+ | 16 | +-----------+ 1 row in set (0.08 sec)
for ur columns, select col+0 from tbl; Mathias Selon Jerry Swanson <[EMAIL PROTECTED]>: > I need to change format from varchar(10) to decimal. > When I alter the table the data is trimmed. > > What I'm doing wrrong? > > TH > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]