Results 1 to 2 of 2
  1. #1
    lion_69 is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2010
    Posts
    2

    Like in SQL

    Like in SQL

    a have create for example next data base

    Name Street
    name1 _street st1
    name2 stre_et st2
    name3 street_ st3
    name4 str_eet st1

    i need that user enter a piece of a street(for example st1) and Access return him Name and Street
    I wrote follow code

    Select....
    From....
    WHERE (([Table name].Street) Like [Enter Street])....
    but it does not work...
    if i enter st1 - do not work
    if i enter str_eet st1 - work.... but it does not that i want)...
    I try to wrote a (%) but access return me an arror
    please help me....

  2. #2
    lion_69 is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2010
    Posts
    2
    answer:
    WHERE ((([Table name].[Street] Like "*" & [enter street] & "*")));

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums