Like in SQL

[lion_69]

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....

[lion_69]

answer:
WHERE ((([Table name].[Street] Like "*" & [enter street] & "*")));