I want to update my table field(by adding new value with previously added value). data type of field is text. query which i tried is as
select notes= cast((convert(nvarchar(max),notes)+ ' ' +convert(nvarchar(max),'shekhar is not here'))as text) from contact1 where accountno='B10228491871N_\vlTes'
This query runs successfully if I use the length of notes data in the text field for the accountNo ='B10228491871N_\vlTes'
eg.
select notes= cast((convert(nvarchar(10),notes)+ ' ' +convert(nvarchar(max),'shekhar is not here'))as text) from contact1 where accountno='B10228491871N_\vlTes'
where I replace first max in convert with 10 ( 10 is the length of the data in notes(text) field.)
also if I use the length more then 10 it does not work ( do not add text )
this will return previous value. how should i add new text value with original value.
this query is running successfully with other db text fields.
( my db was showing 1.6 compatible label when i restored it so i change it as 90.)