On Monday 12 Jan 2004 13:20, Richard Davies wrote:
Thank you to everyone who offered advice on this problem I knew it was easy
but couldn't see how to do it.
Thanks again.
> I receive measurements for a product sometimes in inches, sometimes in
> centimeters.
>
> T
You could do something like (don't copy and paste, this is just for you
to have an ideia - i didn't understand your calculations with 0.063 and
others...):
SELECT IF (metric="cm", expression_in_centimeters, expression_in_inches)
, ...other_fields
FROM ...
where "metric" is the name of the tab
* Richard Davies
> 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
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
> measure
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
