Thanks very much to all who replied, I have enough to work with now. Steve
-----Original Message----- From: Coubes, Sophie [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 2:07 PM To: Morrier, Steve; MI Questions Subject: RE: MI-L SELECT ONLY.... Hi Steve, Try this : Select * From mytable Where Street_Name like "% CR" I hope that can helps you, Kind regards, __________________________________________________ Sophie Coubès / [EMAIL PROTECTED] GIS Consultant KOREM GEObroadcasting Technologies __________________________________________________ 680, Charest East Blvd., Suite 120 Quebec (Quebec) G1K 3J4 Tel.: (418) 647-1555 Fax: (418) 647-1666 1 888 440-1MAP www.korem.com __________________________________________________ * MapInfo Canadian Partner of the Year - 2001 * Best New MapInfo Partner 2000 - North America __________________________________________________ -----Message d'origine----- De : Morrier, Steve [mailto:[EMAIL PROTECTED]] Envoyé : Tuesday, September 24, 2002 1:46 PM À : MI Questions Objet : MI-L SELECT ONLY.... Hi all, Is there a way to start and stop a selection? I want to select all records that have; " CR" - I am looking for Street Names which are Crescents (CR). If I do the following search; InStr(1, Street_Name, " CR ")>0 It returns most of the streets I want but also streets with names like "Ocean Crest DR". Is there a way to say select those with CR only and nothing past CR? TIA. Steve