Steve, If you are assured that the street name ALWAYS ends in "CR" then you could use the Right$() function.
For example, SELECT * FROM Street_Table WHERE Right$(Street_Column, 2) = "CR" You may want to "trim" the street name in order to assure that there are no trailing spaces after the CR that would exclude some records. This is accomplished by: Right$(LTrim$(RTrim$(Street_Column)), 2) = "CR" On a side note...maybe Right$(Street_Column,3) = " CR" would be more applicable... - Ian Erickson ----- Original Message ----- From: "Morrier, Steve" <[EMAIL PROTECTED]> To: "MI Questions" <[EMAIL PROTECTED]> Sent: Tuesday, September 24, 2002 10:46 AM 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: 3228
