Re: finding caseless in memos

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

Article #998

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

#998

From: Keith G. Chuvala (TeamB)
Date: Wed, 27 May 1998 00:00

10 lines
834 bytes

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

No need.  Try this:

  SELECT * FROM alias where <field> LIKE "%something%"

kgc

Technical Details

Message-ID: <356C4398.B7DB8A3E@DELETE_THIS.hit.net>

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: "Keith G. Chuvala (TeamB)" <kgc@DELETE_THIS.hit.net>
Subject: Re: finding caseless in memos
Date: 1998/05/27
Message-ID: <356C4398.B7DB8A3E@DELETE_THIS.hit.net>
X-Deja-AN: 357017310
Content-Transfer-Encoding: 7bit
References: <356B2BCB.4F91@radiok2r.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: First Intermark Corp.
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message