Select names from Field data containing Hyphen
- From: "Lhunt" <Lhunt@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 25 May 2005 21:09:01 -0700
I have an MS ACCESS 2000 database with 9000 lastnames and some are hyphenated.
I want to pull 250 records for lastname "SMITH" andahigher, the first
record it pulls is "SMITH-JAMES" (with the hyphen) then skips the other
SMITH and goes on to SMOOT. I found double quotes work with apostrophies and
confirmed that works, but the Hyphen does not and with some many people
having hyphenated names it seems this is generally a problem.
How can I select this. I have tried
Select top 250 lastname, firstname from PNames where lastname >= '" &
"SMITH" & "'"
Select top 250 lastname, firstname from PNames where lastname like '" &
"SMITH" & "*'"
Select top 250 lastname, firstname from PNames where lastname like '" &
"SMITH" & "%'"
It totaly skips all of the Plain Smiths, returns my first record is
SMITH-JAMES then the next one is SMOOT.
.
- Follow-Ups:
- Prev by Date: RE: Accent insensitive dataview.rowfilter
- Next by Date: ADO from DAO
- Previous by thread: Accent insensitive dataview.rowfilter
- Next by thread: RE: Select names from Field data containing Hyphen
- Index(es):
Relevant Pages
|
|
