Make 1st letter of a field value uppercase in ETL

lthomas · January 10

Is there a way to make the first letter of a value in a field uppercase? Not the entire word, just the first letter…

ColemenWilson · January 10

CONCAT(UPPER(LEFT(`YourField`,1)), SUBSTRING(`YourField`, 2))

ColemenWilson · January 10

CONCAT(UPPER(LEFT(`YourField`,1)), SUBSTRING(`YourField`, 2))

lthomas · January 10

Thanks @ColemenWilson This worked great!

Best Answer