use common

select * from company_detail  where compname like '%jp%'

update company_detail set nextyearcode = 'NEW' WHERE COMPCODE='T23J003'