declare @abc nvarchar(40) set @abc = 'RAND WORLD INT'L FREIGHT FORWARDING CO.,LTD' update myTable set companyname =@abc