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;