Re: LIKE * and ACCESS 97 - 2000 - Article 3856 - go-pugleaf

Article View: borland.public.cppbuilder.database.ado

Article #3856

Back to borland.public.cppbuilder.database.ado Previous Next

Re: LIKE * and ACCESS 97 - 2000

#3856

From: Lee Gan
Date: Fri, 07 Jun 2002 14:33

20 lines
1460 bytes

Use ... LIKE 'a%' ...        Lee Gan...

"Edo" <buildweb@infinito.it> wrote in message news:3cfa7872$1_2@dnews...
> Hi
>
> I use this query:  "SELECT FROM table WHERE name LIKE \"a*\""
> It returns all record with name field like a*
>
> but
> in a personal computer within Win95 and Office 97, this query generates an
> execption.
>
> if I open the same Databese with access in this PC, and I try to run that
> query, it seem good...
>
> can anybody help me?
>
> bye
>
>

Technical Details

Message-ID: <3d00c437_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!news.cs.utwente.nl!newshunter!cosy.sbg.ac.at!news.netway.at!newsfeed01.univie.ac.at!news-fra1.dfn.de!news-han1.dfn.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

References: <3cfa7872$1_2@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,e839b16422ffde3e
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-06-07 07:36:24 PST
From: "Lee Gan" <leegan@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3cfa7872$1_2@dnews>
Subject: Re: LIKE * and ACCESS 97 - 2000
Date: Fri, 7 Jun 2002 08:33:26 -0600
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: 207.34.102.197
Message-ID: <3d00c437_1@dnews>
X-Trace: dnews 1023460407 207.34.102.197 (7 Jun 2002 07:33:27 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!news.cs.utwente.nl!newshunter!cosy.sbg.ac.at!news.netway.at!newsfeed01.univie.ac.at!news-fra1.dfn.de!news-han1.dfn.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

Reply to Parent Message