LIKE prob in access

Results 1 to 2 of 2

Thread: LIKE prob in access

  1. #1
    Join Date
    Dec 1969

    Default LIKE prob in access

    first off..... STOOPID ACCESS!<BR><BR>Hi,<BR>i feel a little better now that i have vented. *deep breath*<BR><BR>ok, heres my prob, i want to use the LIKE with wildcards in my sql statement.... sounds easy right.... pish, i create the sql in access copy and paste it into a variable, run it and VOMIT nuttin.... so fine, i use a select statement and use filter and works fine, but it sounds like i could be exhaustive considering it selects all records then filters it....<BR><BR>has anyone got the like statement to work in sql for access???<BR><BR>if so please, please post it.....<BR><BR>thnx in advance,<BR>steveF

  2. #2
    Join Date
    Dec 1969

    Default RE: LIKE prob in access

    Use star as the wildcard character, not percent sign.<BR>Good luck.<BR><BR>Select * <BR>From Food<BR>Where food_name Like &#039CHOCO*&#039

Posting Permissions

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