I have data in Postgres SQL, something like this
Name Peter C Mcdonald Mccarthy
I am trying to convert first letter after Mc to uppercase , something as below
Name Peter C McDonald McCarthy
I am using initcap function as below, but its not working as expected
Select initcap(name) from table
Appreciate any help!
Advertisement
Answer
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.