I used once in the SQL requester that "where" condition
instr(1,Col_Name," ")>0
JP
Jacques PARIS
e-mail (>>>19.12.00) [EMAIL PROTECTED]
For MapInfo support, see the Paris PC Consult enr. site at
http://www.total.net/~rparis/gisproducts.htm
For MapBasic questions see the J.Paris site at
http://www.total.net/~jakesp/index.htm
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Morrier, Steve
Sent: March 9, 2001 2:36 PM
To: '[EMAIL PROTECTED]'
Subject: MI-L SQL Select
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. Any help would be greatly appreciated. Thanks.
Steve
_______________________________________________________________________
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.
_______________________________________________________________________
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.