By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,677 Members | 1,280 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,677 IT Pros & Developers. It's quick & easy.

Uppercase to lowercase

P: 2
I have an access mailing list. I received it in UPPERCASE and have been able to change the 1st letter to UPPERCASE and the rest to lowercase except that in Proper Names like McDonald, McInnis, they come out as Mcdonald or Mcinnis. I have tried to modify my query to accommodate this; however, unsuccessfully. Here is my query, and wondering how I could change it to accommodate my problem:

UPDATE [All Councils] SET [All Councils].LastName = StrConv([LastName],3), [All Councils].FirstName = StrConv([FirstName],3), [All Councils].Address1 = StrConv([Address1],3), [All Councils].Address2 = StrConv([Address2],3), [All Councils].Address3 = StrConv([Address3],3), [All Councils].Address4 = StrConv([Address4],3);

Dec 9 '09 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 464
I'm not sure how to do this, but we have an access forum that could provide you with more help. To receive better/quicker help in the future please use the proper forum.
Dec 10 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.