Try this also if river is coming with different suffix
name like "%River%" or name like "%name%"
Date: Sat, 11 Sep 1999 19:48:44 +0200
From: Mats Elfström <[EMAIL PROTECTED]>
Reply-to: [EMAIL PROTECTED]
Organization: GisKraft
To: Jonathan Stokes <[EMAIL PROTECTED]>
Cc: "'MapInfo Listers'" <[EMAIL PROTECTED]>
Subject: Re: MI FW: Selecting on text
Jonathan Stokes wrote:
>
> >
> >here's an interesting one..
> >
> >am trying to pull out selected records from a rivers dataset. when i do
> >the query as follows ALL the records in the dataset are selected...
> >
> >Where Condition Name = "River Thames" Or "Thames"
> >
> >????
> >
> >am doing this in MI 4.5.2 WHY!!!!
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
Try
Where Name = "River Thames" Or Name = "Thames"
instead.
The SQL engin cannot guess that the expression after OR also reflects on
Name.
Mats.E
--
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
:Email/ [EMAIL PROTECTED] ICQ#9517386 :
:---------------------------------------------------------------------:
:Mail/ GISKRAFT, Mats Elfstroem, Vaepplingv 21, SE-227 38 LUND, SWEDEN:
:Phones: +46 46 145959, +46 70 595 3935 :
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
===================================================
Aditya
Executive (Systems)
Information Systems Department
GCMMF, Anand
E-mail me at :[EMAIL PROTECTED]
Web Site: http://www.amul.com
===================================================
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]