How to Append string with a text field.

See more:

SQL-Server

SQL-Server-2008

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.)