Modifying names

H

Harvard

Hey guys,

I have a table with 3 fields: first name, last name and email. Some people
enter their name in all caps, or in all lowercase. Is there a way to create
a query that manipulates the first letter in first name to force it to be
uppercase, and the rest of the letters in the name to be lowercase?

Thanks
 
R

Roger Carlson

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top