用友T3清除总账摘要特殊字符或者空格
用友T3清除总账摘要特殊字符或者空格
备份好账套数据 执行语句
update GL_accvouch set cdigest=REPLACE(cdigest,CHAR(9),'') where cdigest like '%'+CHAR(9)+'%'
update GL_accvouch set cdigest=REPLACE(cdigest,CHAR(10),'') where cdigest like '%'+CHAR(10)+'%'
update GL_accvouch set cdigest=REPLACE(cdigest,CHAR(13),'') where cdigest like '%'+CHAR(13)+'%'