UPDATE AccInformation
set cValue=(select CONVERT(INTEGER, Substring(cValue,6,2))
from AccInformation
where cSysID='FA'
and cID='06')
where cSysID='FA'
and cID='04';
set cValue=(select CONVERT(INTEGER, Substring(cValue,6,2))
from AccInformation
where cSysID='FA'
and cID='06')
where cSysID='FA'
and cID='04';