Subject Re: Type mismatch ? From Mervyn Bick <invalid@invalid.invalid> Date Fri, 8 May 2020 22:58:46 +0200 Newsgroups dbase.getting-started On 08/05/2020 22:53, Mervyn Bick wrote: > I'm afraid upper() and lower() can't be used with memo or BOB fields. I should have added "in a query." In a query you are using the localSQL functions upper() and lower() rather than the dBASE DML functions which do work with memo fields. Mervyn.