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
