Make 1st letter of a field value uppercase in ETL

lthomas Member

January 10 in Datasets

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

0

Best Answer

• 

  ColemenWilson Coach

  January 10 edited January 10 Answer ✓

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

  

  If I solved your problem, please select "yes" above

  0

Answers

• 

  ColemenWilson Coach

  January 10 edited January 10 Answer ✓

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

  

  If I solved your problem, please select "yes" above

  0
• 

  lthomas Member

  January 10

  Thanks @ColemenWilson This worked great!

  0