i could not execute update comd

[monirhossen]

update tbl_ApplicantInfo set PinNo=substring(pinno,2,10)

hear pinno is numeric, for this reason this comd is not execute

[Rabbit]

Convert the string to a number using the cast or convert function.

[Frinavale]

Just in case you don't know about the convert or cast functions check out this article about Cast and Convert in SQL.

-Frinny