Alpha searches

Article View: borland.public.delphi.database

Article #2005

Back to borland.public.delphi.database Previous Next

#2005

From: Neil Cowburn
Date: Tue, 16 Mar 1999 00:00

23 lines
1189 bytes

I'm having a bit of a problem trying to figure out how to do alpha searches
in Delphi 4.

The scenario is: I want to be able to search a field for all records that
contain a particular letter or combination of letters e.g. suppose I have a
field called "City" and I want to search the table for all cities (or city
name, more precisely) that contain the letters "an" in that order. It must
be case insensitive too.

Example results:

City
------------
San Francisco
Los Angeles
Bangor
Manchester
Anchorage
... etc, etc.


Thanks in advance, mes amis.
Neil Cowburn.

Technical Details

Message-ID: <7cmbti$klh$1@news7.svr.pol.co.uk>

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: 115d96,cb196d148c768f10,start
X-Google-Attributes: gid115d96,public
From: "Neil Cowburn" <neil.cowburn@denali.co.uk>
Subject: Alpha searches
Date: 1999/03/16
Message-ID: <7cmbti$klh$1@news7.svr.pol.co.uk>
X-Deja-AN: 455729056
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
X-Complaints-To: abuse@theplanet.net
X-Trace: news7.svr.pol.co.uk 921613042 21169 62.136.39.13 (16 Mar 1999 19:37:22 GMT)
Organization: Customer of Planet Online
NNTP-Posting-Date: 16 Mar 1999 19:37:22 GMT
Newsgroups: borland.public.delphi.database