>Hi
>How can I replace string with capital letters to lower but the leftmost character will be upper?
>Thanks
Can you have multiple words in the string? If so, do you want each word to start as upper case?
For Example JOHN DOE becomes John Doe.
In that case, use Robert's suggestion of PROPER().
To get exactly what you asked for (1st letter upper case, all others lower case).........try
UPPER(LEFT(myVar,1)) + LOWER(SUBSTR(myVar,2))