> I recieve measurements for a product sometimes in inches, sometimes in
> These are stored in table1
> int not null primary key, measurement1 int, measurement2 int, type
> I need to extract data from this table and store it in another table with
> 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.
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL