Query question? That seems redundant. But I digress…
I have an oldish database that’s all in lowercase. I wish to capitalize the first letter in each name in the Name column.
Does anyone know of a query in MySQL that could accomplish this?
I know that Oracle has the INITCAP function and that MySQL has nothing like it, but might there be a longer query that could imitate that?
I Googled several search terms, came up with one possible solution, and was given a syntax error for my troubles.
Any thoughts? It would really make my life so much easier. Heh!