Partial-update transaction directly writes a character string at a user-defined position of a table column without issuing a delete and replace command, as would happen in a full update.
Use the rs_updatetext LTL command to implement partial update:
{distribute|_ds} command_tags {applied|_ap} 'table'.rs_updatetext {partialupd|_pu} [{first|_fi}] [last] [{changed|_ch}] [with log] [{withouttp|_wo}] [{offset|_os}=offset {deletelen|_dln}=deletelength] [{textlen|_tl}=length] text_image_column
Partial update does not support multiple character set conversion. Its support is restricted to Microsoft SQL Server 2005.