How can I Lower Case the 1st letter for the word

SQL++
,
1

Hi Guys,

Is there a way in the string functions I could lower case just the 1st letter for the string?

Thanks.

2

CONCAT(LOWER(SUBSTR(str,0,1)),SUBSTR(str,1))

If you want just keep first character as upper case INITCAP(), TITLE()