First off, use the Like operator. Then, MapInfo uses wildcards as follows
(excerpted from the MapBasic help file: why should I be bothered with typing
when I can violate copyright laws?)
----------------------snip---------------------- reformatted and annotated
_ (underscore) matches a single character
% (percent) matches zero or more characters
To find entries that:
start with "South"
Use:
Like"South%"
To find entries that:
end with "America"
Use:
Like"%America"
To find entries that:
contain "ing" at any point
Use:
Like "%ing%"
----------------------snip----------------------
No examples for single character wilds, but I think you get the drift.
The same general info is in the MapInfo help file and can be found with a
"Find" for "wildcards". Offhand I don't know how to find the info from the
Contents or Index. Hmmm....
Sharon Barnes wrote:
> Hello All!
>
> How do you use wildcard characters in SQL? I have a character column
> with names like "FIRELANE 1" "FIRELANE 2" "FIRELANE 3" and I want to
> select any record that has "FIRELANE *" in it. When I tried to use the *
> as a wildcard, it didn't select any of the records. Suggestions anyone?
>
> Thanks in advance for your help.
>
> Sincerely,
> Sharon
>
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
--
Sam Kome
5341 Three Waters Lane
Graham, NC 27253
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
