finding caseless in memos

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

Article #993

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

#993

From: Martin T. Thoma
Date: Tue, 26 May 1998 00:00

15 lines
924 bytes

Hi, it's me again.

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))) ?

Greetings

Martin

Technical Details

Message-ID: <356B2BCB.4F91@radiok2r.de>

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,5c89bcf4147e11d0,start
X-Google-Attributes: gidff5a1,public
From: "Martin T. Thoma" <martin@radiok2r.de>
Subject: finding caseless in memos
Date: 1998/05/26
Message-ID: <356B2BCB.4F91@radiok2r.de>
X-Deja-AN: 356750630
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql