🚀 go-pugleaf

On Wed, 27 May 1998 11:47:20 -0500, "Keith G. Chuvala (TeamB)"
<kgc@DELETE_THIS.hit.net> wrote:

>> This works fine, when field is a String-Field, but an error occurs, when
>> field is a memo. How can I turn memos into upper-case ? Or can I turn
>> memos into text (something like UPPER(STRING(memofield))) ?
>
>No need.  Try this:
>
>  SELECT * FROM alias where <field> LIKE "%something%"

That would depend on whether he is using the 16- or 32-bit BDE. Given the
error that prompted his original post, I suspect he has the 32-bit BDE.

In the 16-bit version of the BDE, LIKE predicate comparisons were always
case-insensitive. Convenient, but not compliant with standard SQL. The
32-bit version of the BDE changed this functionality such that LIKE
predicate comparisons are now (correctly) case-sensitive. For CHAR type
columns, this is not a major problem, as the UPPER function can be used to
convert column and comparison value to the same casing.

Unfortunately, the 32-bit BDE also changed the applicability of the UPPER
function. It can no longer be used with memo columns. This prevents using
UPPER to make a comparison case-insensitive.

**************************************************************************
Steve Koterski
INPRISE Corporation, Technical Publications
http://www.inprise.com/delphi