Determining Whether a Specific String Exists in a Field "L.A. Lawyer" <kapplaw[ at ]linkline.com> 12/9/2008 5:01:36 PM I want to determine whether a specific string of letters exists in a field on the current field. How is that done?

Re: Determining Whether a Specific String Exists in a Field "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_gmail.com> 12/9/2008 5:08:53 PM You can use LIKE for the criteria of a query: SELECT Field1 FROM Table1 WHERE Field1 LIKE "*Lawyer*" or you can use the InStr function. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "L.A. Lawyer" <kapplaw[ at ]linkline.com> wrote in message news:uK37DAiWJHA.5760[ at ]TK2MSFTNGP05.phx.gbl... [Quoted Text] >I want to determine whether a specific string of letters exists in a field > on the current field. > > How is that done? > >