🚀 go-pugleaf

VdB 7.01 (b1419)

Anybody know how to do a query on memo fields and circumvent the
problem of case of the string being searched?

For example:

  pcField is the chosen field
  pcSearchValue is the string to search

  insert into '<table1>' select * from '<table2>' where
upper(&pcField.) like '%' + :pcSearchValue + '%'

The above works well if the field is Char. But, if the field is a memo
field, you get the error: Database Engine Error: Type mismatch in
expression as long as you try to convert the field to upper in the
statement.

With DML, you could filter on upper(<memo>). What do we do with OODML?

Ned