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
