Being a beginner in SQL, I am trying to do the telephone fields to be noted in the format: '"+" + country identifier + telephone number'.

```
UPDATE public.contact 
   SET phone_number = CASE WHEN (country_code ='FR') 
                                AND phone_number NOT LIKE '+33%' 
                                AND phone_number <> NULL 
                                THEN CONCAT('+33', phone_number)
                           WHEN (country_code ='GB')and phone_number NOT LIKE '+44%' 
                                AND phone_number <> NULL 
                                THEN CONCAT('+44', phone_number)

```

I want to update telephone number format to include country identifier like : 0606080905-> +33606080905 if country\_code='FR' . I am looking for a faster and less complex way than what I did.