Re: UPPER and memo fields

Article View: borland.public.vdbase.data.sql

Article #1358

Back to borland.public.vdbase.data.sql Previous Next

#1358

From: Ken Chan
Date: Tue, 10 Feb 1998 00:00

13 lines
863 bytes

J. Korth wrote:
> I need to check with an SQL query for a text string in a memo field of
> a dbf table. This should be done not case sensitive.
> However, SQL UPPER() seems not to work with memo fields:

While some SQL dialects support a "case-insensitive LIKE" (I believe 
Interbase does this), local SQL does not. You can use the canGetRow event 
for this.

-- 
//Ken[0]@Borland
<Please follow-up to newsgroup; do not reply to email>

Technical Details

Message-ID: <MPG.f4a8561a1ec34399897e5@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <6b4qs9$51q10@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,efb4658663119c4a
X-Google-Attributes: gidff5a1,public
From: supportinfo@borland.com (Ken Chan)
Subject: Re: UPPER and memo fields
Date: 1998/02/10
Message-ID: <MPG.f4a8561a1ec34399897e5@forums.borland.com>
X-Deja-AN: 324012915
References: <6b4qs9$51q10@forums.borland.com>
Organization: Borland
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message