Re: upper

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

Article #132

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

#132

From: Michael Rotteck
Date: Wed, 20 Jan 1999 00:00

20 lines
899 bytes

On Tue, 19 Jan 1999 23:33:55 +0100, "Jens Korth"
<XJens.KorthX@wanadoo.fr> wrote:

>Hello,
>
>is there any way to use upper() in combination with a dbf memo field in a
>sql statement?
>
>I would like to check for a string in a memo field, not case sensitive, e.g.
>
>select * from tablename where upper(memofield) like '%searchstring%'
>
>cangetrow is terrible slow.....
>
Hi Jens,

UPPER and LOWER are not working with memofields.

--
Michael Rotteck

Technical Details

Message-ID: <36a57f26.86299642@forums.borland.com>

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

References: <7831f0$cf66@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,2c2d6093b8c70b4d
X-Google-Attributes: gidff5a1,public
From: 100277.441@compuserve.com (Michael Rotteck)
Subject: Re: upper
Date: 1999/01/20
Message-ID: <36a57f26.86299642@forums.borland.com>
X-Deja-AN: 434724346
References: <7831f0$cf66@forums.borland.com>
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message