Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I would like to capitalize the first letter of a field but to keep other words fixe
example :
alcDefG => AlcDefG
I tried Capitalize but there is not the requirement
Thanks
Use this:
Upper(left(Fieldname,1))&Mid(Fieldname,2,len(Fieldname)-1)
I don't need to Capitalise every word : for Exemple if i have dEEpak sharma I need to have
DEEpak sharma...
I tried this before posting my question but it doesn't work
it works thank you
Hi zied, Can you post a sample? that should work
It's directly saying: set first letter as uppercase and add other characters as they are. (3rd parameter for Mid is not really needed as you want all characters from the 2nd)
Edit: Ok
Welcome