SQL statement to capitalize the first letter

[#1]

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

[#2 · Accepted solution]

With hive query,  please try 

select concat(UPPER(SUBSTRING(fieldname,1,1)),LOWER(SUBSTRING(fieldname,2,LENGTH(fieldname)))) AS fieldname from ...

[#3 · Accepted solution]

Hello @Sam7 

We hope the SQL shared by @BennyZ helped your Team meet the Use-Case. Showing the SQL Output from the SQL shared in a Sample Table:

As such, We are marking the Post as Solved. 

Regards, Smarak

[#4]

Thank you