* 6/11/2012 3:51:37 PM, 1, KELVIN ONG CHEONG KEONG *
Update POS_SALESDTL Set  SDTL_SEQNO = SDTL_SEQNO - 9000,  SDTL_DTLLINK = SDTL_STORE || '-' ||  SDTL_CTRNO || '-' ||  Right('000000000' || Cast(SDTL_TRANSNO As VarChar(10)),10) || '-' ||  Right('00000' || Cast(SDTL_SEQNO As VarChar(6)),6)  Where  SDTL_SEQNO > 9001