Is this about fixing the data or implementing a case insensitive search? What database are you using?
Thomas > On 22 Apr 2016, at 10:20, Satya Miller <[email protected]> wrote: > > ** > Morning! > > I was hoping someone has an idea to help me with something. I have a form > that has two fields (First Name and Last Name) in it. The data is not > "clean." I need to convert the data in these two fields to Proper Case. In > other words, capitalize each word, or if possible even Capitalize correctly > like O'Connell. I searched the ARSList and the last suggestion was from > 2005. I was hoping there might be a better solution now. > > Thanks in advance for you help. > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
