Re: How to Find a Substring into a .DBF field with Local SQL

Article View: comp.lang.pascal.delphi.databases

Article #225

Back to comp.lang.pascal.delphi.databases Previous Next

#225

From: Manuel Cuevas
Date: Tue, 10 Dec 1996 00:00

30 lines
1300 bytes

Hi, Martin !

Martin Cativa Gronda <moonred@satlink.com> wrote:

>For example find the record "NEW YORK" when I enter "YORK" as substring.

>I tried SELECT * FROM "BASE.DBF" WHERE Statename=:VAR1

Try

      	SELECT * FROM "BASE.DBF" 
	WHERE StateName LIKE ( '%'+:VAR1+'%' )

Regards,

                                               Manuel Cuevas
                                  wwwmaster@mbytesl.com

        Manuel Cuevas

    wwwmaster@mbytesl.com
    http://www.mbytesl.com

  100115.314@compuserve.com

   CIS        : 100115,314
   Fidonet    : 2:345/606
   Virnet     : 9:341/302
   ClipperNet : 225:345/601

Technical Details

Message-ID: <32ad28a6.0@news.arrakis.es>

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

References: <327BEAAA.2D5A@satlink.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,be4a8ea247772e3f
X-Google-Attributes: gidffff5,public
X-Google-Thread: 10baee,be4a8ea247772e3f
X-Google-Attributes: gid10baee,public
X-Google-Thread: 109585,be4a8ea247772e3f
X-Google-Attributes: gid109585,public
From: macugi@arrakis.es (Manuel Cuevas)
Subject: Re: How to Find a Substring into a .DBF field with Local SQL
Date: 1996/12/10
Message-ID: <32ad28a6.0@news.arrakis.es>
X-Deja-AN: 203293484
references: <327BEAAA.2D5A@satlink.com>
organization: MegaByte Internet
newsgroups: comp.lang.pascal.delphi.databases,comp.lang.pascal.delphi.misc,es.comp.lenguajes.delphi

Reply to Parent Message