Subject Re: Change Upper Case From Mervyn Bick <invalid@invalid.invalid> Date Sat, 1 May 2021 09:54:37 +0200 Newsgroups dbase.getting-started On 2021/05/01 02: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 > A simple little XDML program will do this for you.  It has the added advantage that any index on the filed will be  "fixed" aw well. use whatever scan replace all fieldname with proper(fieldname) endscan use Mervyn.