Re: UPPER(Memo field)

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

Article #560

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

#560

From: Michael Rotteck
Date: Fri, 09 Oct 1998 00:00

28 lines
1199 bytes

On Thu, 08 Oct 1998 20:44:16 -0700, David Jones
<106510.502@compuserve.com> wrote:

Hi Dave,

Local SQL UPPER and LOW are not working with memo fields.
 
>I've tried to use the following SQL code in VdB 7.01, where Companies is 
>a DBF table and Contacts is a Memo field and contact is a character 
>variable with upper-case values:-
>
>UPDATE Companies SET Tempflag1=0 WHERE UPPER(Contacts) NOT LIKE 
>'%'+:contact+'%'
>
>This results in the error 'Type mismatch in expression'.
>
>However, the same code without the UPPER() function works OK but is, of 
>course, case-sensitive.
>
>The problem appears to be peculiar to Memo fields - character fields work 
>OK.
>
>Can anyone advise on this one, please?
>
>Dave

--
Michael Rotteck

Technical Details

Message-ID: <361dff62.68562657@forums.borland.com>

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

References: <361D8690.3544@compuserve.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,2fe72fe88314414f
X-Google-Attributes: gidff5a1,public
From: 100277.441@compuserve.com (Michael Rotteck)
Subject: Re: UPPER(Memo field)
Date: 1998/10/09
Message-ID: <361dff62.68562657@forums.borland.com>
X-Deja-AN: 399340236
References: <361D8690.3544@compuserve.com>
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message