How to TRIM OR TRUNCATE first character in DB2 column

Question

I have column phone number with value and want to update the table column such that country code doesnt exist. 19083452345 14084456789 12023458900 18163456789

I tried to use LPAD, LTRIM but couldnt succeed.

Answer 1

Something like this using SUBSTR:

update tablename set phone=substr(phone,2,length(phone)-1)