-
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....
-
answer:
WHERE ((([Table name].[Street] Like "*" & [enter street] & "*")));
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules