>
>declare @abc nvarchar(40)
>set @abc = 'RAND WORLD INT'L FREIGHT FORWARDING CO.,LTD'
>update myTable set companyname =@abc
>
>
> ^^^^^^^^^^ this statment invalid , How can I correct it ??
>Thanks
As Naomi siggested just double single quote inside the string:
declare @abc nvarchar(40)
set @abc = 'RAND WORLD INT''L FREIGHT FORWARDING CO.,LTD'
update myTable set companyname =@abc
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.