I have data in Postgres SQL, something like this I am trying to convert first letter after Mc to uppercase , something as below I am using initcap function as below, but its not working as expected Appreciate any help! Answer Use above query it will give desired results.

Postgres SQL to convert first letter after Mc to upper case

I have data in Postgres SQL, something like this

Name
Peter C Mcdonald
Mccarthy

​x
 
NamePeter C McdonaldMccarthy​

I am trying to convert first letter after Mc to uppercase , something as below

Name
Peter C McDonald
McCarthy

 
NamePeter C McDonaldMcCarthy​

I am using initcap function as below, but its not working as expected

Select initcap(name) from table

 
Select initcap(name) from table​

Appreciate any help!

Select case when name like '%Mc%' then concat(split_part(name,'Mc',1),'Mc',initcap(split_part(name,'Mc',2))) else name end from table

 
Select case when name like '%Mc%' then concat(split_part(name,'Mc',1),'Mc',initcap(split_part(name,'Mc',2))) else name end from table​

Use above query it will give desired results.