[SOLVED] proper name format (first letter capitalized)?

Is it possible to ensure that a user doesn't use all lower case or all upper case in a field? I'd like to save certain fields with first letter of each word capitalized if possible.

You could use CB Auto Action with a query action and uppercase the first letter of the string/column after the registration trigger. This would automate the process. I believe I've posted a query to upper case the first letter and lowercase the rest, but you'll have to search as can't recall the thread.

searched hi and low but found no query.

how about this?

UPDATE #__comprofiler
SET firstname =
CONCAT(UCASE(substr(firstname,1,1)), substr(firstname,2));

Confirmed the below works.

First letter uppercase:
First letter uppercase and rest lowercase:

I found a nice function to do this here: joezack.com/index.php/2008/10/20/mysql-capitalize-function/

I have tested it and it does work well.

Does this set up look ok? Can I run more than one query in the box so I can also do firstname and lastname with one trigger?

Does this set up look ok?

You're missing a trigger. Your query also has unnecessary line breaks; try to keep it 1 line and let it wordwrap if needed.

Can I run more than one query in the box so I can also do firstname and lastname with one trigger?

Yup, end your first query with a ; then add a line break (press enter/return) and add a new query. You can add as many as you like actually.