upper

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

Article #123

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

#123

From: Jens Korth
Date: Tue, 19 Jan 1999 00:00

14 lines
776 bytes

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

--
Jens Korth
Sainte Anastasie, Gard, Languedoc, France

Technical Details

Message-ID: <7831f0$cf66@forums.borland.com>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,2c2d6093b8c70b4d,start
X-Google-Attributes: gidff5a1,public
From: "Jens Korth" <XJens.KorthX@wanadoo.fr>
Subject: upper
Date: 1999/01/19
Message-ID: <7831f0$cf66@forums.borland.com>
X-Deja-AN: 434578425
Organization: Another Netscape Collabra Server User
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Newsgroups: borland.public.vdbase.data.sql