View the original community article here
Last tested: Dec 13, 2019
Most SQL Dialects have a function like INITCAP() that automatically capitalizes the first character of a string. See:
We can do this using Table Calcs with an example like:
We use concat to combine to substring functions.