Subject Re: touppercase From Mervyn Bick <invalid@invalid.invalid> Date Fri, 7 Oct 2022 12:23:38 +0200 Newsgroups dbase.getting-started On 2022/10/05 08:30, Helen Prior wrote: > Hi > I am trying to do a 'like' search on a memo field - I now have it working thanks to Mervyn but it is case senstitive - Most of the text is lower case but names etc have the first letter in upper and so I want to ignor case - In the help files there is a command 'touppercase' which reading the text seem to do what I need but it is how to contruct the command is the problem. > OR is there a better way? > Could anyone help please? > Regards Helen A little alarm has just gone off in the back of my mind which had me scratching in the localSQL help file. The like predicate in localSQL only works with character fields (which have a max length of 254 characters) and not with BLOB (memo) fields. Is your "memo" field actually a character field? Using the LIKE predicate, especially where the first character in the search string is a % wildcard, is one of the most onerous tasks a SQL engine can be asked to perform.  There is a programming technique to get round this but it depends on what exactly is in the field you want to search.  If you care to post one or two examples of the contents of the field I may be able to suggest an alternative. Mervyn.