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 all
measurements converted to inches.
insert into table2 select from table1 no, measurement1+0.625,
Would it be possible to have a field in table1 that indicates centimeters or
inches and modify the insert statement to check this field and divide
everything by 2.54 before adding and inserting? If this is possible how would
I do it I can't quite make it work.