"Morrier, Steve" wrote:
>
> Does anybody know the proper syntax for selecting on those records within a
> field that contain two words or more. I need to select all street names with
> in a file that are more than one word. Basically I am concerned with any
> entry that has a space in it.
Hi Steve!
I suggest you use the string operator 'like' this way:
Select * from MyTable where MyField like "% %" into Selection
The % is a wildcard equal to * in these cases.
Regards, 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 :
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
