Try where Right$(Street_Name, 3) = " CR" Michael Hanna
-----Original Message----- From: Morrier, Steve [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 1:46 PM To: MI Questions Subject: 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: 3225
