>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