use t202627

UPDATE RECEIVED_DETAIL SET COMPSRNO='000186' WHERE COMPSRNO='S'

SELECT MAX(COMPSRNO) FROM RECEIVED_DETAIL  WHERE COMPSRNO<>'S' AND RecFirmCode = '17TM001' and len(recsrno)=6