Fran,
The MapBasic help file gives you this sort of information. I have attached
the following excerpt which relates to SQL selections (using MB, but same
principles apply). Also from the MB help, on the like statement:
The pattern_string parameter can contain the following wild-card characters:
_ (underscore) matches a single character
% (percent) matches zero or more characters
I agree that this is not well documented in the MapInfo help. If you search
for wildcards, this info is under the heading "Comparison Operators". This
is in the index under "Operators" - so the indexing is pretty poor.
Hope this helps,
Chris Perry
Systems Development CoOrdinator
Parks Victoria
Melbourne, Australia
Ph: 61 3 9816 6800
Fax: 61 3 9816 9876
[EMAIL PROTECTED]
-----Original Message-----
From: Fran Peck [mailto:[EMAIL PROTECTED]]
Sent: Friday, 14 January 2000 4:58
To: Mapinfo List (E-mail)
Subject: MI SQL question
Is there reference material that gives a better explanation of SQL select in
MI than the reference and user's guides that come with it? The reference
guide lacks what should be simple things such as the use of like statements,
wildcards, etc. Since every sql handles these statements slightly
differently, it would be good to have a reference to the use. Thanks in
advance.
Fran Peck
Peoria Unified School District
6330 W Thunderbird Rd
Glendale, AZ 85306
Voice: 623-486-6099
Fax: 623-486-6111
Email: [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
sqlselect.rtf
