Subject Re: touppercase From Andy Taylor <andy.taylor.1959@outlook.com> Date Fri, 7 Oct 2022 11:05:56 +0100 Newsgroups dbase.getting-started Hi Helen, dBase/localSQL can certainly search ignoring case. The trick is to search in a version of the memofield content that is either all UPPER or all lower. Mervyn explains well the use of the available functions but seeing extracts of your code will help us diagnose the problem. Any chance of that? Andy > Dear Mervyn > Thank you for the upper/lower - That partially works but fails if the first character is in upper and the rest of the search word is in lower. > Going back to touppercase > Will this command permanently lower case to upper case? - If so how might that be achieved? > That might hopefully be the answer - It is so frustrating that dbase/sql cannot search ignoring upper/lower case > Regards > Helen