How to Search such record

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

Article #3466

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

#3466

From: HuangC
Date: Fri, 02 Aug 2002 08:50

10 lines
1458 bytes

I want search in database that accord my request, I can do some simply
query, now I want search the record that include a keyword in one field, not
all the content of the field
Can I use a SQL statement to query the accordant record.

For example: suppose I have a Database that about pathology, I want search
all the record that include 'cancer' in 'diagnose' field, It't include, not
always all the content.

Thanks for any advice.

Technical Details

Message-ID: <3d4a47da$1_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!news3.cnt.ru!srcc!newsfeed.gamma.ru!Gamma.RU!newsfeed1.cidera.com!Cidera!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!news-in-sanjose!in.nntp.be!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,679d71d5dccfc870,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-08-02 02:06:07 PST
Reply-To: "HuangC" <HuangC913@Msn.com>
From: "HuangC" <HuangC913@Msn.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: How to Search such record 
Date: Fri, 2 Aug 2002 16:50:31 +0800
Lines: 12
Organization: Motic
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
NNTP-Posting-Host: 210.15.1.114
Message-ID: <3d4a47da$1_2@dnews>
X-Trace: dnews 1028278234 210.15.1.114 (2 Aug 2002 01:50:34 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!news3.cnt.ru!srcc!newsfeed.gamma.ru!Gamma.RU!newsfeed1.cidera.com!Cidera!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!news-in-sanjose!in.nntp.be!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews!not-for-mail