Sqlite add column based on another columns value

I have a first_name field in a sqlite database. I want to alter this database by adding a first_initial column and make it's value the first character of first_name followed by a period. How do would I go about setting the value of first_initial, can it be done from the alter statement?

ALTER TABLE mytable ADD COLUMN first_initial TEXT;