Capitalize first letter in string

[Anonymous]

Hi I have a Question:

What is the best/simplest way to capitalize the first letter in a string

[Anonymous · Accepted solution]

alright, after about one hour trial and error I found a solution:

concat(first(toupper('susanne')),substring('susanne',1,sub(length('susanne'),1)))

If anyone has an easyer solution I would much appreciate it 🙂

[umakanta84]

There are different ways to make it : 

if you want to make first letter of a word to Capitalized then you can use Proper.

ex : Proper("umakanta swain")   output : Umakanta Swain

if you want to Capitalize only first character of the string/sentence then

ex:  mystring = what is your name umakanta ? Left(mystring,1) & Right(mystring, Len(mystring)-1)

output : What is your name umakanta ?