Knowledge Drop

Use Table Calculations to Capitalize First Letter of String (INITCAP)

Userlevel 5

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.


This content is subject to limited support.                



0 replies

Be the first to reply!