Helen Prior <email@example.com>
||Wed, 05 Oct 2022 02:30:35 -0400
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?