how can we get starting letter of a word capital when data in database in all capital letters

[#1]

how can we get starting letter of a word capital when data in database in all capital letters

[oknotsen]

Use the Capitalize function:

Capitalize - script and chart function ‒ Qlik Sense

[OmarBenSalem]

=Capitalize( Lower(YourField))

[viveksingh]

Capitalize(Field_Name)

this gives data like below

Dheeraj

Ram

Raj

Vijay

Sreekanth