Re: finding caseless in memos

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

Article #1005

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

#1005

From: Ken Chan
Date: Wed, 27 May 1998 00:00

13 lines
933 bytes

hirschv at mindspring dot com (Ken Mayer [TeamB]) wrote:
> You can't, as far as I can tell. UPPER() will not work with a memo,
> because there is no known limit to the size of the memo itself ... 

The SQL UPPER() function does not work on blob/memo fields.

The dBASE UPPER() function does work on memo fields -- it takes the 
string contents, as long as it does not exceed the max string limit.

-- 
//Ken@Inprise
<Please follow-up to newsgroup; do not reply to email>

Technical Details

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

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

References: <356B2BCB.4F91@radiok2r.de> <356b6475.2203265@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,5c89bcf4147e11d0
X-Google-Attributes: gidff5a1,public
From: supportinfo@borland.com (Ken Chan)
Subject: Re: finding caseless in memos
Date: 1998/05/27
Message-ID: <MPG.fd62a2bcaf235b989972@forums.borland.com>
X-Deja-AN: 357116693
References: <356B2BCB.4F91@radiok2r.de> <356b6475.2203265@forums.borland.com>
Organization: Borland
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message