I have table where one column is defined as nvarchar. I would like to update the value in this column with kannada text ,
Update doctor set a.docname = b.doctorname
from doctor a inner join
select rowid, doctorname from doctor
) b on a.rowid = b.rowid
doctorname is in english. i want to update docname in kannada translation of doctorname.