HELP SQL 'LIKE' clause

Results 1 to 3 of 3

Thread: HELP SQL 'LIKE' clause

  1. #1
    Join Date
    Dec 1969
    Posts
    613

    Default HELP SQL 'LIKE' clause

    I am using Access97 and am trying to use the example given in the article on this site entitled: A Nifty Little Talble Search" &#060;or something to that effect>... When I run the search query, I get this error: >[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression &#039LIKE &#039%scott%&#039&#039.... What am I doing wrong? <BR><BR>Any help would be great!!<BR><BR>Scott

  2. #2
    Nathan Pond Guest

    Default RE: HELP SQL 'LIKE' clause

    Might try using * instead of % for access.. not sure but something to try.

  3. #3
    Join Date
    Dec 1969
    Posts
    511

    Default RE: HELP SQL 'LIKE' clause

    It helps if you post the code and a tidy version of your SQL string. From your post though it looks like you might have got your " and &#039 mixed up a little, your query should look something like this :<BR><BR>SELECT *<BR>FROM MyTable<BR>WHERE MyField LIKE &#039Test&#039<BR><BR>From your post it looks like you might have missed the last &#039 off or put a " instead?<BR><BR>hope that helps<BR><BR>Pete

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •