UPDATE  CM_ACCOUNT
SET TK_GL ='361200001', TK_GL_NAME =(SELECT ACC_NAME FROM CM_ACCOUNT WHERE ACC_NO ='361200001')
WHERE LEN (ACC_NO) >9
AND SUBSTRING(ACC_NO,4,4) ='7048'

UPDATE  CM_ACCOUNT
SET TK_GL ='519200002', TK_GL_NAME =(SELECT ACC_NAME FROM CM_ACCOUNT WHERE ACC_NO ='519200002')
WHERE LEN (ACC_NO) >9
AND SUBSTRING(ACC_NO,4,4) ='7044' AND SUBSTRING(ACC_NO,12,2) ='19'

UPDATE  CM_ACCOUNT
SET TK_GL ='421100001', TK_GL_NAME =(SELECT ACC_NAME FROM CM_ACCOUNT WHERE ACC_NO ='421100001')
WHERE LEN (ACC_NO) >9
AND SUBSTRING(ACC_NO,4,4) ='7041'