I was trying to use the code from the article: "A Nifty Table Searching Script <BR>By Jerry Wood "<BR><BR>I am using an Access97 database that is very simple; have not cahnged his code except to name the DSN...when I run the search for Scott, I get this error: <BR>SELECT * FROM BrochureRequest WHERE LIKE &#039%scott%&#039 &#060;font face="Arial" size=2><BR>&#060;p>Microsoft OLE DB Provider for ODBC Drivers&#060;/font> &#060;font face="Arial" size=2>error &#039 80040e14&#039&#060;/font><BR>&#060;p><BR>&#060;font face="Arial" size=2>[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression &#039LIKE &#039%scott%&#039&#039.&#060;/font><BR>&#060;p><BR>&#060;font face="Arial" size=2>/gnw/SearchField.asp&#060;/font>&#060;font face="Arial" size=2>, line 86&#060;/font> <BR><BR>Now line 86 is this: rsRecords.Open SQL, dbConn, 3<BR><BR>I don&#039t get it...I have yet to have something like this work.<BR><BR>Any help would be awesome!<BR><BR>Scott<BR><BR>