修改某一字段时为空时则赋值，不为空时则累加的SQL语句

update Lab_Sample set OperatingRecord = 
(case when OperatingRecord is null then '修改操作记录' else OperatingRecord+'修改操作记录' end) 
where ID=109

IBATIS 写法：

        <isNotEmpty property="OperatingRecord" prepend=",">OperatingRecord = (case when OperatingRecord is null then #OperatingRecord# else OperatingRecord+#OperatingRecord# end)</isNotEmpty>