I want to update a price with sql.
The price collum in the DB is nvarchar ant the price format is: ex: 4,080000
After running this sql update, the price is:
I need the price to be: 4,19
update pricetable set price = cast(price as money) + '0,11'
Can anybody help?