>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
Hi Chaim
lcname = "Chaim Halevy Works At Dor Yeshorim"
lnendp = at(" ",lcname)
lcfirst = substr(lcname, 1, lnendp)
lcname = proper(lcfirst) + lower(stuff(lcname,1,lnendp,""))
HTH
Claudio
"Now to him who is able to do immeasurably more than all we ask or imagine, according to his power that is at work within us, Ephesians 3:20