How do I run an update query in a field that is varchar? I'm trying to set the values in field "metricvalue" to a new value but my guess is that you can't multiply varchar values? This is my syntax:
update tblmetricdata
set metricvalue = metricvalue * 1.5
where metricid between 119 and 130
and modelid = 282
which gives this error message. "Arithmetic overflow error converting numeric to data type numeric.
The statement has been terminated."
Thanks for any help )
update tblmetricdata
set metricvalue = metricvalue * 1.5
where metricid between 119 and 130
and modelid = 282
which gives this error message. "Arithmetic overflow error converting numeric to data type numeric.
The statement has been terminated."
Thanks for any help )