MySQL function?

On Mon, Sep 22, 2003 at 02:05:32PM -0700, Matt Alexander wrote:
/_Mike Starke said:
/_>
/_> Is there a function in MySQL similar to that in Excel's "proper()"?
/_>
/_> For instance, I would like to do a select on a column that has
/_> all CAPS and display the query in proper case (Mike versus MIKE).
/_
/_select concat(ucase(left(first_name,1)),lcase(SUBSTRING(first_name,2)))
/_as First_Name from myTable;

Thanks. Getting closer. My problem is when you have a value like "MR. FUDDS DELI"
in the column; you get "Mr. fudds deli" instead of "Mr. Fudds Deli".

-mike