I have Table A which has columns Product_id & Product_Price. Table B has Product_id & Product_desc.
Product_id is type char(30). product_Price is smallmoney and Product_desc is nvarchar (2000).
I am trying to produce a query which for each value of Product_id, we take Product_desc add TEXT followed by product_price x 4.
So I am thinking that I start with Update Table B SET Product_desc = Prouct_desc + TEXT but when I run this sql reports Conversion failed when converting the varchar value '180110"" ' to data type int.
My second problem is the correct syntax to append product_price.
I would be very grateful for some help with this please.