help - how can i use condition ?

Hello everyone; I would like to create a column1 in a table from another column0; Column1 must contain letters as follows: If a text field in column 0 starts with the letter A write A in column ...