UPPER and memo fields

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

Article #1423

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

#1423

From: J. Korth
Date: Mon, 02 Feb 1998 00:00

15 lines
674 bytes

Hello,

I need to check with an SQL query for a text string in a memo field of
a dbf table. This should be done not case sensitive.
However, SQL UPPER() seems not to work with memo fields:

  Select......  Where UPPER(table.memofield) LIKE '%SEARCH EXPRESSION'

This does not work.

Any workarounds?

Thanks
Jens

Technical Details

Message-ID: <6b4qs9$51q10@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,efb4658663119c4a,start
X-Google-Attributes: gidff5a1,public
From: airports@aol.com (J. Korth)
Subject: UPPER and memo fields
Date: 1998/02/02
Message-ID: <6b4qs9$51q10@forums.borland.com>
X-Deja-AN: 321384256
Organization: None
Newsgroups: borland.public.vdbase.data.sql