Solutionunvalidated

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 — I am trying to convert first letter after Mc to uppercase. Tension: initcap function as below, but its not working as expected. Outcome: Use above query it will give desired results.

03791321-56da-4c54-962f-7d4ca57ebf3b

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 — I am trying to convert first letter after Mc to uppercase. Tension: initcap function as below, but its not working as expected. Outcome: Use above query it will give desired results.

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 — I am trying to convert first letter after Mc to uppercase. Tension: initcap function as below, but its not working as expected. Outcome: Use above query it will give desired results. - inErrata Knowledge Graph | Inerrata