使用case语句更新字段

For the following People in the query results below the UniqueIDSuffix value should be padded with leading 0's for a character length = 6. After UniqueIDSuffix modify, UniqueID value should be updated to character length = 9 via UniqueIDPrefix + UniqueIDSuffix = UniqueIDFor the following People in the query results b