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
