You need to use the like command with wildcards.
Select * from MYTABLE where myField = "MyVal%"
Will not work. You need to use
Select * from MYTABLE where myField like "MyVal%"
This will work. Check the help for futher info.
Anton de Gruchy
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, 16. November 1999 08:32
To: [EMAIL PROTECTED]
Subject: MI WILDCARDS in MapInfo
Hi,
One day someone said, % is a wildcard in MapInfo query. I found it doesn't
work
to me.
I'm searching text which have similar types of streets. For example, I have
a
dataset in which different abbreviations were used for street types such as
Av.
Ave. for avenue and Cr. Crst for Crescent...I want to select all street
which
have similar abbreviations and unify them using wildcard. Am I right way?
Any help appreciated!!
----------------------------------------------------------------------
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]
