https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/28409.aspxWed, 30 Apr 2008 05:37:27 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:28409Clay Fox0https://www.infopathdev.com:443/forums/thread/28409.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=28409<p>Yah you want to look at the translate function. I am guessing if you search on it you will find some examples.</p> <p>With that you can translate all upper case to lower case and then get your synchronization.</p>https://www.infopathdev.com:443/forums/thread/28406.aspxTue, 29 Apr 2008 23:05:14 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:28406astephen0https://www.infopathdev.com:443/forums/thread/28406.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=28406<p>I&#39;ve got an access database which I&#39;m using to receive Office information (Address, Street Numbers etc etc) and the field in which I want to validate which Address is populated contains the Town and comes from another Database.</p> <p>&nbsp;The issue I&#39;m having is that some of the Towns in the database are in lower case and some in upper. This wouldnt normally be a problem as I could adjust the small access database to be the same but for example one Advisor has his office as SYDNEY and one as Sydney so I cannot adjust accordingly.</p> <p>Basically the question is: can I add something to the following&nbsp;field formula to ignore the case:</p> <p>@PostalAddress[@BranchName = Advisor_Suburb]</p> <p>Thanks in advance for your help, this website has been priceless for me.</p> <p>Alex</p>