Sharon,
In MapInfo, the wildcard character is % and, of course you need to use the
"like" operator, not "="
Chris Perry
Manager Mapping Systems
Parks Victoria
Melbourne Australia
Ph: 613 9816 6800
Fax: 613 9816 7222
[EMAIL PROTECTED]
-----Original Message-----
From: Sharon Barnes [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 4 February 1999 8:09
To: MapInfo List
Subject: MI SQL wildcard character.
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]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
