Update set substring of field to literal

[wooddsw]

Has anyone been able to accomplish something like this statement?

Update tablename set substring(field,10,15) = 'value'

I want to update data burried inside a text field but continue getting:

Incorrect syntax near '('

Any help offered would be greatly appreciated

 

[swampBoogie]

Update tablename 
set field = 
stuff(field,10,15,'value')

 

[wooddsw]

A great point in the right direction....THANKS!

Now the problem is complicated by the fact that my FIELD is a TEXT datatype. When using your syntax is tells me that argument 1 (I guess FIELD) is an invalid datatype for this function.

Can you steer me any further or am I up a creek now!

 

[swampBoogie]

If your column contains less than 8000 characters you should be able to use

Update tablename
set field =
stuff(cast(field as varchar(8000)),10,15,'value')

otherwise you probably need to take a record at a time using readtext and updatetext

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ua-uz_6i2c.asp