Re: finding caseless in memos

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

Article #997

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

#997

From: hirschv at mindspring dot com Ke...
Date: Wed, 27 May 1998 00:00

28 lines
1453 bytes

"Martin T. Thoma" <martin@radiok2r.de> wrote:

>Got the folowing problem: I want to do a caseles search in a
>paradox-table using a SQL-Query. I did the following:
>
>SELECT * FROM alias WHERE UPPER(field) LIKE UPPER("searchstring")
>
>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))) ?

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 ... 

Curiously enough this isn't covered in the online help. I am pretty
sure this limitation exists, however. If I'm wrong, I'm sure someone
will correct me.

Ken

---
Ken Mayer [TeamB]
Golden Stag Productions
http://www.mindspring.com/~hirschv/homepage.htm
http://www.mindspring.com/~hirschv/dbase/dbase.htm

Please respond in the newsgroup unless explictly asked otherwise

Technical Details

Message-ID: <356b6475.2203265@forums.borland.com>

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

References: <356B2BCB.4F91@radiok2r.de>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,5c89bcf4147e11d0
X-Google-Attributes: gidff5a1,public
From: hirschv at mindspring dot com (Ken Mayer [TeamB])
Subject: Re: finding caseless in memos
Date: 1998/05/27
Message-ID: <356b6475.2203265@forums.borland.com>
X-Deja-AN: 356815121
References: <356B2BCB.4F91@radiok2r.de>
Reply-To: hirschv@nospam.mindspring.com
Organization: Golden Stag Productions
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message