* Richard Davies
> 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,
> measurement2+0.063, 'Style';
> 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.
It's possible. Changing the table to include a 'inches-flag':
ALTER TABLE table1 ADD inches TINYINT NOT NULL;
This defaults to 0 (=false=centimeters). Set it to 1 to indicate that inches
Output as centimeters:
Output as inches: