Thanks very much to all who replied, I have enough to work with now.
Steve
-Original Message-
From: Coubes, Sophie [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002 2:07 PM
To: Morrier, Steve; MI Questions
Subject: RE: MI-L SELECT ONLY
Hi Steve,
Try this :
Select
th America
__
-Message d'origine-
De : Morrier, Steve [mailto:[EMAIL PROTECTED]]
Envoyé : Tuesday, September 24, 2002 1:46 PM
À : MI Questions
Objet : MI-L SELECT ONLY
Hi all,
Is there a way to start and stop a selection? I want to select a
Steve,
You could try using the LIKE operator:
Select * From Streets Where Street_Name Like "%CR"
This should select everything that ends in "CR".
HTH,
Gary.
"Morrier, Steve" wrote:
>
> Hi all,
>
> Is there a way to start and stop a selection? I want to select all records
> that have;
> " C
t;Morrier, Steve" <[EMAIL PROTECTED]>
To: "MI Questions" <[EMAIL PROTECTED]>
Sent: Tuesday, September 24, 2002 10:46 AM
Subject: MI-L SELECT ONLY
> Hi all,
>
> Is there a way to start and stop a selection? I want to select all records
> that have;
>
To: 'HANNA MICHAEL (TOR1MMH)'
Subject: RE: MI-L SELECT ONLY
THANKS VERY MUCH!!! What is the 3 for? 3rd position or 3 spaces??
-Original Message-
From: HANNA MICHAEL (TOR1MMH) [ mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> ]
Sent: Tuesday, September 24, 2002 1:51
Try where Right$(Street_Name, 3) = " CR"
Michael Hanna
-Original Message-
From: Morrier, Steve [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002 1:46 PM
To: MI Questions
Subject: MI-L SELECT ONLY
Hi all,
Is there a way to start and stop a selection? I want
Hi all,
Is there a way to start and stop a selection? I want to select all records
that have;
" CR" - I am looking for Street Names which are Crescents (CR). If I do the
following search;
InStr(1, Street_Name, " CR ")>0
It returns most of the streets I want but also streets with names like
"Oce