🚀 go-pugleaf

I've tried to use the following SQL code in VdB 7.01, where Companies is 
a DBF table and Contacts is a Memo field and contact is a character 
variable with upper-case values:-

UPDATE Companies SET Tempflag1=0 WHERE UPPER(Contacts) NOT LIKE 
'%'+:contact+'%'

This results in the error 'Type mismatch in expression'.

However, the same code without the UPPER() function works OK but is, of 
course, case-sensitive.

The problem appears to be peculiar to Memo fields - character fields work 
OK.

Can anyone advise on this one, please?

Dave