Hi, > I recieve measurements for a product sometimes in inches, sometimes in > centimeters. > > These are stored in table1 > int not null primary key, measurement1 int, measurement2 int, type > varchar(255) > > I need to extract data from this table and store it in another table with all > measurements converted to inches.
You have a different problem here. If it's a single column that holds both centimeters AND inches, depending on another column value, then you have a design problem. Not an SQL problem. A column should only hold one value. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
