Code:
update tbl_ApplicantInfo set PinNo=substring(pinno,2,10)
hear pinno is numeric, for this reason this comd is not execute