Update Query to Set text to Proper Case

Leesha
BronzeLounger
Posts: 1433
Joined: 05 Feb 2010, 22:25

Update Query to Set text to Proper Case

Post by Leesha »

Hi!
Can an update query be used to set the text in table to proper case. I have [address1] in tblClientdemographics and many of the addresses are in upper case. I would like them to be consistently in proper case.
Thanks!
Leesha

User avatar
HansV
Administrator
Posts: 75751
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Update Query to Set text to Proper Case

Post by HansV »

Yes:

UPDATE tblClientdemographics SET address1=StrConv(address1,3)

3 is the numeric value of the symbolic constant vbProperCase.

The same warning applies that I mentioned in your earlier thread about names. MCDONALD DRIVE will be converted to Mcdonald Drive, not McDonald Drive.
Regards,
Hans

Leesha
BronzeLounger
Posts: 1433
Joined: 05 Feb 2010, 22:25

Re: Update Query to Set text to Proper Case

Post by Leesha »

Thanks Hans! I appreciate the help and the tips!