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 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3230
