Access 2003 - Capitalize first letter using queries

Question

SOLUTION

update COUNTRY set CO= StrConv ([CO], 3)

---

Hi:

How I can capitalize the first letter and all other letters in lower case? I need to do this using queries from own Access.

Example, if I have stored countries: SPAIN, FRANCE, ITALY, ....I want to change them to: Spain, Italy, France,....

hanks in advance

Answer 1

Have a look at MS Access: StrConv Function