According to the Presto docs, there is not currently a function to convert a string to title case.
The typical standard name of such a function is initcap(string) from what i can tell.
This can be done using regex_replace. There's an example in the documentation: https://prestosql.io/docs/current/functions/regexp.html
```sql
SELECT regexp_replace('new york', '(\w)(\w*)', x -> upper(x[1]) || lower(x[2]));
-- 'New York'
Thats a good workaround. Imho it would be good to have an actual function initcap or so.
Most helpful comment
Thats a good workaround. Imho it would be good to have an actual function initcap or so.