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
