Write Function in SQL Server 2005

One of the functions available in SQL Server 2005 that allows you to update a character column of size max is WRITE Function. In fact we can consider this as alternate to STUFF function which wont work for columns with Max length

declare @t table(v nvarchar(max))
insert into @t select 'test is test'
update @t set v=stuff(v,1,4,'This')
select v from @t

declare @t table(v nvarchar(max))
insert into @t select 'test is test'
update @t set v.write('this',0,4)
select v from @t

PS

You can use STUFF function in both SELECT and UPDATE Statement but WRITE function can be used only in UPDAET statement preceded by Column name.