Steve, You could try using the LIKE operator:
Select * From Streets Where Street_Name Like "%CR" This should select everything that ends in "CR". HTH, Gary. "Morrier, Steve" wrote: > > 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 -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Gary Schwartz Director of Software Development Mapping Analytics 2 Graham Road West Ithaca, NY 14850 (585) 271-6490 [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3229