RE: MI-L MapInfo Wildcard?

2004-03-25 Thread Jacques Paris 
Shouldn't it simply be "%jo%" ?

Jacques Paris


-Original Message-
From: Michael Smith [mailto:[EMAIL PROTECTED]
Sent: 25-Mar-04 10:11
To: 'MAPINFO-L'
Subject: MI-L MapInfo Wildcard?

Hi,
I am trying to run an sql query of my streets map file to make some changes
to the street names.  What I would like to do is select any street in my
streets table that has a portion of a text string such as find all streets
that contain the letters "jo".  The query would then pull johnson st, jones
st, etc.  I can't seem to get this working it is looking for exact matches.

Select:  Roads
Where:  streetname = "jo%"

This does not work.  Does anyone know the correct wildcard or use of the
wildcard?  Thanks in advance.

Mike


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11098



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11103

RE: MI-L MapInfo Wildcard?

2004-03-25 Thread Terry McDonnell 
Mike

You could try something like:

select * from roads where Instr( 1, Ucase$( Roads.streetname), "JO")
into selection

-Original Message-
 Hi,
I am trying to run an sql query of my streets map file to make some
changes
to the street names.  What I would like to do is select any street in my
streets table that has a portion of a text string such as find all
streets
that contain the letters "jo".  The query would then pull johnson st,
jones
st, etc.  I can't seem to get this working it is looking for exact
matches.

Select:  Roads
Where:  streetname = "jo%"

This does not work.  Does anyone know the correct wildcard or use of the
wildcard?  Thanks in advance.

Mike




-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11102

RE: MI-L MapInfo Wildcard?

2004-03-25 Thread Michael Smith 
Thanks guys for your help!  I was close, just needed to change from = "jo%"
to LIKE "jo%"

Select:  Roads
Where:  streetname LIKE "jo%"


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11101

RE: MI-L MapInfo Wildcard?

2004-03-25 Thread Campbell, Keith A 
Mike,

Try

Select:  Roads
Where:  streetname Like "jo%"

Regards,

Keith

-Original Message-
From: Michael Smith [mailto:[EMAIL PROTECTED] 
Sent: 25 March 2004 15:11
To: 'MAPINFO-L'
Subject: MI-L MapInfo Wildcard?


Hi,
I am trying to run an sql query of my streets map file to make some changes
to the street names.  What I would like to do is select any street in my
streets table that has a portion of a text string such as find all streets
that contain the letters "jo".  The query would then pull johnson st, jones
st, etc.  I can't seem to get this working it is looking for exact matches.

Select:  Roads
Where:  streetname = "jo%"

This does not work.  Does anyone know the correct wildcard or use of the
wildcard?  Thanks in advance.

Mike


-
List hosting provided by Directions Magazine | www.directionsmag.com | To
unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11098


This email and any attached files are confidential and copyright protected.
If you are not the addressee, any dissemination of this communication is
strictly prohibited. Unless otherwise expressly agreed in writing, nothing
stated in this communication shall be legally binding.



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11099