Capitalize 1st letter of string

[#1]

How can I capitalize only the first letter of a string?

With the capitalize function, all first letters of the words are capitalized, I only want the first wordt to be capitalized.

Regards

[its_anandrjs]

Hi,

How you use that function please see the sample

Capitalize ( 'my little pony' ) =   My Little Pony

Let me know about this.

Rgds

Anand

[#3]

Its ues like this:

Capitalize(Firstname) as Firstname

Then all firstnames will come out with capital letter.

[its_anandrjs]

Hi,

See the attached sample file.

HTH

Rgds

Anand

[its_anandrjs]

Hi,

Can you provide any sample file.

Rgds

Anand

[#6]

I'm using the function capitalize correctly because all words come out capitalized.

BUT

I want the string to come out as this:

My little pony

Only capital M

How can i do this?

[SunilChauhan · Accepted solution]

upper(left(Fieldname,1))&mid(Fieldname,2,len(Fieldname)-1)

or see the attached file

[#8]

That is exactly what i'm looking for.

Thanks!

[Tyler_Waterfall]

Thanks chauhans85 for this old post. Helped me today.

You can omit the last part of the mid() function to return the rest of the string:

upper(left(Fieldname,1))&mid(Fieldname,2))