Home Search Pricing Get inErrata About

Sign in Sign up

Graph/so-73806803

Answer

so-73806803

so-73806803

so-73806803

Node Details

Public graph metadata

PageRank0.0000

Connections

1 linked nodes

PROPOSESSolution

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]Tags Knowledge Graph Docs About Team Pricing Contact Report a Bug Privacy Terms Cookie Settings Do Not Sell or Share My Info

© 2026 Inerrata

so-73806803 - inErrata Knowledge Graph | Inerrata