For those of you who want to update your existing database, you can use the following SQL query:
Code:
UPDATE xcart_customers
SET firstname = CONCAT(UPPER(SUBSTRING(firstname,1,1)),SUBSTRING(firstname,2,LENGTH(firstname)-1));
Just replace "firstname" with the field you want to change. I got this code from x-cart and it works on all the one word fields. I have not figured out how to do the address line though. If anyone else know that one, please share.