About Sam7

Sam7 · ‎11-05-2021

Thank you

Sam7 · ‎11-04-2021

Thanks for the support. How do I make the second word a capital too?

Sam7 · ‎10-11-2021

Cheers, I did not see that. Can I remove a tag or shall I start again with my question.

Sam7 · ‎10-11-2021

What is das? This is the first time I am using this code, very new to Hue

Sam7 · ‎10-07-2021

Hi, I want the first letter to be a capital letter and the rest lower case: UPPER(LEFT(fieldname,1))+LOWER(SUBSTRING(fieldname,2,LEN(fieldname))) AS fieldname I keep getting this error: Error while compiling statement: FAILED: ParseException line 25:10 cannot recognize input near 'LEFT' '(' 'fieldname' in function specification Please help

Online	Offline
Last Visited	‎11-05-2021 11:11 AM

Member Since	‎10-07-2021 08:30 AM
Last Visited	‎11-05-2021 11:11 AM
Posts	5

Cloudera Community

Re: SQL statement to capitalize the first letter

Re: SQL statement to capitalize the first letter

Re: SQL statement to capitalize the first letter

Re: SQL statement to capitalize the first letter

SQL statement to capitalize the first letter