I have a table with the following columns:

```
CREATE TABLE Projects
(
       Project_ID int IDENTITY(1,1) PRIMARY KEY,
       Project_Code varchar(255),
       Request_Date Date DEFAULT GETDATE(),
       Region varchar(255),
       Project_Location varchar(255),
       Requested_By varchar(255),
       Project_Responsibility varchar(255),
       Facility_Classification varchar(255),
       Project_Type varchar(255),
       Expected_Start_Date varchar(255),
       Expected_End_Date varchar(255),
       Work_Areas varchar(255),
       Conference_Rooms varchar(255),
       IDF_MDF varchar(255),
       Pantries varchar(255),
       Critical_Infrastructure varchar(255),
       Building_Support_Areas varchar(255),
       Data_Centers varchar(255),
       Other_Areas varchar(255),
       Project_Manager varchar(255),
       Project_Owner varchar(255),
       Project_Sponsor varchar(255),
       Functional_Currency varchar(255),
       Approval_Status varchar(255) DEFAULT 'Not yet approved',
       CIP_NCIP varchar(255),
       Capital_Expense varchar(255),
       Fiscal_Year varchar(255),
)

```

I want to update the table such that when the approval status of any record changes to approved, I want to auto populate the project code column using a combination of region, location and id. 

Is this possible to do so in SQL Server? If so how?