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);
Tks
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);
Tks
Comment