add the column value

[cho16]

Hi ,

If any part of the Name column that contains Pediatric it should be updated as Pediatric care center in the Participat column.

Id   Name                                           Participat

1  PM Pediatrics                                         aaa

2  PM Pediatrics of Bayside                       bbb

3  Pediatrics oF selden                              ccc

4   Pediatrics                                                ddd

5  Urgent care Ny                                         eee

Want:

Id   Name                                           Participat

1  PM Pediatrics                                         Pediatric care center

2  PM Pediatrics of Bayside                       Pediatric care center

3  Pediatrics oF selden                              Pediatric care center

4   Pediatrics                                                Pediatric care center

5  Urgent care Ny                                         eee

Thanks in advance

[novinosrin · Accepted solution]

if index(name,'Pediatric') then Participat='Pediatric care center';