>
>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
You have a single quote inside abc. You can double it or use different text delimiter.
If it's not broken, fix it until it is.
My Blog