Subject Re: Change Upper Case From Tim Ward <tim@goldengrovenurserydotcodotuk> Date Sat, 1 May 2021 08:52:00 +0100 Newsgroups dbase.getting-started On 01/05/2021 01:38, roy price wrote: > I am using the gridcolumnindexchange.cc on my form, which seems to work well. > However the field containing text descriptions sorts words starting with upper case letter as different to those starting with a lower case letter. > The first words all start with an upper case letter, but subsequent words in the field may have either. (poor input standard) > Is there any program that would go through the records and change all words to always start with an upper case letter. > I hope to avoid the laborious editing that would make for consistency. > (obviously I would prefer not to try to modify the gridcolumnindexchange.cc program to use the UPPER() function in the index.) But that may be the way to go. > Regards > Roy Price > Hi Roy, There is also the function PROPER() which capitalizes the first letter of all words. regards Tim