Another option:
Transform(yourfield,'!'+Replicate('x',9999))
>Proper function change thefirst character in all words, I want only the first word.
>>Use proper()
>>
>>>Hi
>>>How can I replace string with capital letters to lower but the leftmost character will be upper?
>>>Thanks