SQLite Forum

Capitalize first letters only
Login
Is there some function / method to capitalize only the first letter of **each** word in a text field?

I looked at `upper()` for a possible optional parameter to do this but no.

I also looked at `printf` but didn't see a relevant format.

Any other way?
Perhaps, a loadable extension someone has written and willing to share?

Example:

`my name`

should become:

`My Name`

Thank you.