The 3 is for 3 characters. The fact that you're using the Right$() function already establishes that you're refering to the right-most positions. gladly, Mike
-----Original Message----- From: Morrier, Steve [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 1:54 PM To: 'HANNA MICHAEL (TOR1MMH)' Subject: RE: MI-L SELECT ONLY.... THANKS VERY MUCH!!! What is the 3 for? 3rd position or 3 spaces?? -----Original Message----- From: HANNA MICHAEL (TOR1MMH) [ mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ] Sent: Tuesday, September 24, 2002 1:51 PM To: Morrier, Steve; MI Questions Subject: RE: MI-L SELECT ONLY.... Try where Right$(Street_Name, 3) = " CR" Michael Hanna -----Original Message----- From: Morrier, Steve [ mailto:[EMAIL PROTECTED] <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
