How to retrieve field from sqlite db and apply a function to a particular column

asked 2019-10-21 12:38:00 -0500

I have SQLite DB and there are 8 columns one of which is Phone Number. I have a function written which will check if the number length is 10 and not starting with 1 then it will add 1 at the start of the phone number. My problem is how to get that particular field and apply this function.

edit retag flag offensive close merge delete