DECLARE @ptrval binary(16) SELECT @ptrval = TEXTPTR(InfoTxt) from U_info where id <> 14 UPDATETEXT U_info.InfoTxt @ptrval null 0 'aaa'
updata tableName set infoTxt=infoTxt+¡°aaa¡± where id ¡¶¡·14 ¼± ¼± À´ÈËѽ!! Çë½Ì ¼±??? SQL code: update U_info set InfoTxt = InfoTxt +'aaa' where id <> 14 ;
updata tableName set infoTxt=infoTxt+'aaa' where id<>14
select @ptrval=textptr(infoTxt) from tableName where Ìõ¼þ if(textvalid('tableName.infoTxt',@ptrval)=1) updatetext tableName.infoTxt @ptrval 0 null @infoTxt